Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Variance column in matrix

Hi,   How can I create a third column in a matrix to show variance YOY, without creating individual measures for reach value of Revenue, Costs, Profit, etc.?     2018 2019 third column for ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

= divide(sum(2019)-sum(2018),sum(2018))

or

measure =

var _a =sum(2019)-sum(2018)

return

divide(_a,sum(2018))

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi amitchandak 

 

Thanks for the quick reply.

 

I'm not sure how I can do "sum(2019)"?

 

Cheers,