Forum Discussion
Divide Total values
Hello,
Is it possible to divide Total values and add it to a new measure?
For example in this screenshot, I would like to divide the 80/100, where both are measure values already.
Thank you,
Hayman
"Is it possible to divide Total values and add it to a new measure?"
Don't know what this means. Do you mean create a new measure in this same table that just shows the quotient at the "Total" row? Or display in a completely different table/visual? Because all you should have to do is:
Divide Measure = DIVIDE( [TI_Cumulative] , [IMPE_Cumulative] )
2 Replies
Please advise.
Regards,
Hayman
"Is it possible to divide Total values and add it to a new measure?"
Don't know what this means. Do you mean create a new measure in this same table that just shows the quotient at the "Total" row? Or display in a completely different table/visual? Because all you should have to do is:
Divide Measure = DIVIDE( [TI_Cumulative] , [IMPE_Cumulative] )