topic Create percent calculated between 2 variables in SAS Visual Analytics

Create percent calculated between 2 variables

DartRodrigo — Tue, 17 May 2016 14:08:52 GMT

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

Re: Create percent calculated between 2 variables

Sam_SAS — Tue, 17 May 2016 18:12:07 GMT

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