Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Icon for Post Prodigy rankPost Prodigy
9 years ago

Waterfall chart adding percentages up in total column?

I am using a waterfall chart showing gross margin %.   The issue I am running into is that instead of showing period over period fluctuations it just keeps adding the percentages:   Periods  |  P...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi Frederico,

 

You refer that in absolute values it works but in percentage the values aren't right. How are yout calculaiting percentages?

 

Regards,

MFelix

Frederico's avatar
Frederico
Frequent Visitor
8 years ago

I am approaching them in two different ways according to the needs. Examples below.

 

Measure% = (sum(valueA) + sum(valueB)) / sum(BaseValue))

or

Measure% = sum(valueA) / sum(BaseValue)