本文介绍了水晶报表中的计数公式错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我想写公式来计算其中alvalid ="Valid"和金额字段AlAmountIp >0,

我已经尝试过但无法正常工作,请问有人可以帮我吗

i want to write formula to count in which alvalid="Valid" and amount field AlAmountIp >0,

i have tried but its not working,can any one help me pls

If(((LowerCase(Trim(CStr({Symphony_Care5000_TPA_Reports_TPARetrieveServiceAgent_UnutilizedAuthorization.ALValid})))) ="valid") and (CDbl({Symphony_Care5000_TPA_Reports_TPARetrieveServiceAgent_UnutilizedAuthorization.AlAmountIp}))>0 ) then

Count({Symphony_Care5000_TPA_Reports_TPARetrieveServiceAgent_UnutilizedAuthorization.AlAmountIp})


其计数显示错误,请回复[REMOVED] @ hotmail.com


[edit]更正了标签并删除了电子邮件[/edit]


its count is displaying wrong,pls reply to [REMOVED]@hotmail.com


[edit] corrected tags and removed email [/edit]

推荐答案


这篇关于水晶报表中的计数公式错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-15 14:15