Matrix Porcennajes

[eloyhernandez]

Hello

I have a report that shows me the data in an array, but one of the data I calculate is the % between one column and another but when calculating the automatic totals the Matrix sums me the percentages and the result is not correct.

I attach a screenshot.

As I can fix it so that the result is correct, or at least do not show me totals in the % common and if in the rest.

[Mariusz]

Hi @eloyhernandez 

You can wrap your original expression with 

IF( HASONEVALUE( table[Area_Nom] ), your expression )

This will return blank on Grand Totals

Or the below with an extra argument that calculates totals correctly

IF( HASONEVALUE( table[Area_Nom] ), your expression, another expression for total ) 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[amitchandak]

@eloyhernandez , your formula seems to have some issue. Can you share it?

It should be like sum(A)/Sum(B) not Sum(A/B)