[Existing] = if([Prior]<>0 and [Current]<>0,[Prior]-[Current],0)
[Repaid] = if([Current]=0,[Prior],0)
[New] = if([Prior]=0,[Current],0)
Very simple and straight forward. I get the totals correctly.
However, I would like to get rid of the Client column a so that I can show just the Balances for all the clients. When Clients are excluded from the dimension, then the calculations change as the calculation just becomes between the fields and not for each client I have.
How do I run my totals on Clients without having Client as a dimension?
Hi, my totals for my Inputfield are not including the original source totals. I would like them to include together. It seems to total on the detail but not the summary totals. How do I get it to summarize to include the input additions? Any help you can provide would be greatly appreciate.