水晶报表中的计数公式错误 [英] formula for count in crystal report in wrong

问题描述

我想写公式来计算其中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]

推荐答案

尝试使用运行总计字段而不是您自己的公式字段.

try to use running total field instead of your own formula field.

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