Forum Discussion
Calculated column is giving wrong result
Hi, I want to create 2 new calculated columns like follows incoming = if [Debit/Credit] = S then [amount in company code currency] outgoing = if [Debit/Credit] = H then ...
hi, Anonymous
For your case, I think it is because the calculate column value is aggregated in the visual.
Please set them don't summarize, or change [amount in company code currency] is SUM
Best Regards,
Lin
Anonymous ,
I don't how you are getting incorrect results. I used same method howver I am getting correct results.
https://1drv.ms/u/s!Ah0UhoGdkH5biiJPFN0W1s6GvEox?e=z1LTbx
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.