05-17-2016 10:04 AM - edited 05-17-2016 10:08 AM
How can i create a calculated percentage with 2 variable in visual analytics.
Var1 / Var2
I want to calculate the percentange relating the var1 with var2.
Thanks in advance
05-17-2016 02:12 PM
You can just make a calculated measure with the expression, Var1 / Var2, then set the format of the calculated measure to be Percent and set the aggregation to be Average.
In this screenshot, "Ratio" is my calculated item whose expression is
MSRP / Invoice
Is that what you were looking for?