Been quite some time since I have been here. Thought I would see if you guys have a reference to something you have probably answered before.
I need to do a formula to do a common size (percent of total) calculation except on the grandparent groupby summary.
Something like this pseudo code AColumnAmount / GrandParent:Sum(AColumnAmount)
Thanks for any help you might reference me too!
Nick
Hi Nick,
I'm not entirely sure exactly what you want. Can you explain in more detail or maybe provide a sample or some screen shots?
In accounting they call it a common size calculation. It's a % of a total. However in this case it's a % of a total of totals.
Hope this makes it a little clearer.
Thanks,
Group: Ops
Hi,
If you need any additional assistance with this case feel free to contact me.
Regards
This is the sample
Hello Nick,
There are different approaches to solve this task. I made small sample with one of these solutions. Please take a look at the attached sample for more details and let me know if you have any questions.
Regrads
Okay. And by "formula" you mean you are using UltraCalcManager?
You will probably need a series of formulas here, but the only really tricky part will be referencing the grandparent summary as a relative reference in a formula.
I could probably whip up a quick sample for you, but there are some variable here that I'm not sure of. For example, are the groups here OutlookGroup groups created by the grid? Or is that your data structure?
Maybe you could create a small sample project with just the data and post it here and that way it will remove all ambiguity. Then I could edit it with the appropriate formulas for you. You can attach a zip file to your post by going to the Options tab when posting.