I have the following issue and need help ASAP…please…
ID Amnt CD
1 100 A
1 100 B
2 200 A
2 200 B
In the report when a variable is use
If CD <> “D” then sum (amnt)
I am getting a multivalue error. I know i am using there are 2 amounts for 2 different CD thats why? how can i fix this multivalue error. PLease help ASAP?
Thanks
Thanks but whatever Jansi provided still doesnt work and am getting the multivalue error. I have said it is not equal to “D” coz i want all the amnts other than “D”.
Also i thought if i can use the Where clause instead of If, but i am getting a context error when i use.