calculated value in set analysis

[#1]

Hi,

I have the following expression.  Essentially, I am trying to limit the records to one record, based on the average daily volume.  The first example shows one department that has an average daily volume of 53.  however, this can change from month to month, or department to department .

sum ({$<AVG_DAILY_VOL_DESC ={'53)'}>} RESOURCING)

However, this can change from month to month, or department to department .  This doesnt work. However, the calculation does return the correct average daily volume.

sum({$<AVG_DAILY_VOL_DESC ={round(avg({$<MEASURES_DESC={'AVG DAILY VOL'}>}FORECAST_VALUE ))}>} RESOURCING)

So I put the calculation above into a variable called varADV and embedded that in the expression.  This doesnt work.

sum ({$<AVG_DAILY_VOL_DESC ={'$(varADV)'}>} RESOURCING)

What am I missing here?

[#2 · Accepted solution]

The syntax for variables in set analysis is a bit different. You will need $(#variable) for variables and $(#=expression) for expression. So in your case use either

sum({$<AVG_DAILY_VOL_DESC ={$(=round(avg({$<MEASURES_DESC={'AVG DAILY VOL'}>}FORECAST_VALUE )))}>} RESOURCING)

or

sum ({$<AVG_DAILY_VOL_DESC ={$(=$(#varADV))}>} RESOURCING)