2 Replies Latest reply on Oct 24, 2017 5:05 PM by Zhouyi Zhang

Parameters in aggregated Calculations

Vijaymakesh Rajgopal Oct 24, 2017 4:47 PM

I am trying to include a parameter in a caculation that contains an if condition

My data looks like this

I have 2 parameter, lets say "A_input" and "B_input". Calculation i am looking for is:

if Location = "A" then

Avg(Salary) * [A_input]

elseif Location = "B" then

Avg(Salary) * [B_input]

else Avg(Salary)

I am not getting this to work. I keep getting mixing aggregated and non aggregated values. How can i solve this?

1. Re: Parameters in aggregated Calculations

Deepak Rai Oct 24, 2017 5:03 PM (in response to Vijaymakesh Rajgopal)

if Location = "A" then
Avg(Salary) * ATTR([A_input])
elseif Location = "B" then
Avg(Salary) *ATTR( [B_input])
else Avg(Salary)
End
Like Show 0 Likes(0)

Actions
2. Re: Parameters in aggregated Calculations

Zhouyi Zhang Oct 24, 2017 5:05 PM (in response to Vijaymakesh Rajgopal)

Hi, Vijaymakesh

you can add ATTR() to your location field as below

IF ATTR([Location]) = "A" THEN
AVG([Salary])* [A_input]
elseif ATTR(Location) = "B" then
Avg(Salary) * [B_input]
else Avg(Salary)
END

Hope this could help

ZZ
Like Show 0 Likes(0)

Actions

Tableau Community