Click here to Skip to main content
15,793,609 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi,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


its count is displaying wrong,pls reply to [REMOVED]

[edit] corrected tags and removed email [/edit]
Updated 24-Apr-12 12:44pm
Nelek 24-Apr-12 17:45pm    
Don't wait for anyone answering to your email. First of all it is a bada idea to post an email into a public forum, you might get it full of spam. Second, if you ask for help to get ride of a problem, the less you can do is do a bit work and come back to answer people that might try to help you and/or give feedback is the proposed solution helps or not

1 solution

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

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900