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]