Create percent calculated between 2 variables

[DartRodrigo]

Hi all,

How can i create a calculated percentage with 2 variable in visual analytics.

For example:

Var1 

1020 

Var2

13000

Var1 / Var2 

I want to calculate the percentange relating the var1 with var2.

Thanks in advance

[Sam_SAS]

Hi,

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?

Thanks,

Sam