hari krishna

hari krishna

  • NA
  • 1
  • 2.2k

Formula for count in crystal report in wrong

Apr 24 2012 1:41 PM
hi,i want to write formula for  count in which alvalid="Valid" and amount field AlAmountIp is >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})

its count is displaying wrong,pls reply to [email protected]