Variable with Set Modifier

[Upali_Wijearatne]

Hi Friend

I have created a variable as shown in Scn 1 and I want add  set modifier to it only at the expression of my pivot table. I have tried it as shown marked in red color. But It does not work, But if I use as shown in scn 2 It works. Kindly help me add set modifier to varible

[eddie_wagt]

Hello @Upali_Wijearatne ,

Is it possible to share data or QVW? Otherwise it will be hard to see what you exactly are trying to achieve. It looks like you want to add a set modifier within an expression that you have declared as a variable. If you want to add an set modifier you will have to make a 'placeholder' within the expression you have written under vActual.

vActual = sum({$<DECRIPTION={'Sales'}$(vBusinessRule1)>}ACTUAL)

In this way you can define vBusinessRule1 (with a condition)....?

But again it is hard to help you without the example..

Regards Eddie