Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Create percent calculated between 2 variables

Reply
Regular Contributor
Posts: 212

Create percent calculated between 2 variables

[ Edited ]

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

SAS Super FREQ
Posts: 296

Re: Create percent calculated between 2 variables

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.

 

ratio.png

 

In this screenshot, "Ratio" is my calculated item whose expression is

MSRP / Invoice

 

Is that what you were looking for?

 

Thanks,

Sam

Ask a Question
Discussion stats
  • 1 reply
  • 224 views
  • 0 likes
  • 2 in conversation