Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to find the % of the filed [Open Balance] to the Total([Open Balance]).
The issue is that I have to find this percentage in the [SheetName] I have picked.
For Example:
Total Open Balance is $10,000,000.
I select only one [SheetName]
Open Balance in the [SheetName] I have selected is $1,500,000.
After that I select a Client. I am looking for my text box to show:
The sum of that clients [Open Balance] / The Total [Open Balance] for that [SheetName].
Any help is much appreciated. And if further clarification is needed please let me know.
My original thoughts were using some sort of variable.
Thanks!!!
-Jim
May be like this:
Sum([Open Balance])/Sum({<SheetName>} [Open Balance])
Where you make selection in SheetName
or
Sum([Open Balance])/Sum({1} [Open Balance])
something like this....
Sum([Open Balance])/Sum(Total <SheetName> [Open Balance])