How can I correctly display a revenue ratio?

Question

How can I correctly display a revenue ratio (costs as a percentage of  of revenue) in Board?No matter what I've tried so far, as soon as I have row and column totals, the ratios for the totals are not displayed correctly.

* I used a cube without an account entity, into which I only wrote the revenue.
* I used the original cube and applied a block reference (Refer to) on revenue.
* I tried working with algorithms, dividing sums by count.
* I tried Last Value, Min, Max, Avg.

Nothing has resulted in getting the correct ratios in the rows as well as in the Totals and Grand Totals.

Additional note:

As soon as you use the “Last Value,” “AVG,” “Min,”  “Max” or other functions, the total cell in the Totals section is blank.Is this a bug or intended behavior? I would expect to see the corresponding values in the Totals section here.

Robert Barkaway · Answer

Ah I see, an understandable (and not uncommon) ask but one that does complicate matters.

Depending on which Board version you're using, since B14 Quick Layout has been enhanced to allow specification of mandatory entities and also which must be the most nested, that would potentially allow them to drag in other entity levels while keeping Account as the most nested and ensuring the rule continues working, just a thought.

Niklas Multerer · Answer

Thanks for your quick reply, Robert

We deliberately didn't use a Rule. The client still wants to be able to drill on the totals, and possibly also pull additional entities below the current entity into the Layout. That would not be possible with a Rule either way.

Robert Barkaway · Answer

Hi Niklas, the usual way to calculate something like that would be using a rule, then you can apply the rule to totals as well. I think the issue you're encountering there is maybe to with the order in which Board resolves some calculations vs when it calculates algorithms.