Sum of grand total of transactions

JessicaThibod

Hi, 

 

I am trying to sum a column within a module on open balances for all of my bill-to Customers. The reason for me doing this is I have them by aged deductions and then I used the SUM function onthe aging buckets to get the total of that particular customer. Now I would like a calculation that tells me what the percentage of that Customer has open compared to the overall balance of all Bill-To Customers.

VIGNESH.M

Hi Jessica,

 

Try the below method,

 

Check the link for more detail,

https://community.anaplan.com/t5/Anaplan-Discussions/Need-Formula-Help/m-p/41894#M4432

 

 

~Vignesh