本文介绍了水晶报表中的计数公式错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想写公式来计算其中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]
推荐答案
这篇关于水晶报表中的计数公式错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!