Conditional Sum

[jeckstein]

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

[sunny_talwar]

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])

[vikramv]

something like this....

Sum([Open Balance])/Sum(Total <SheetName> [Open Balance])