Set Analysis - how to use variable vlaue inside set analysis

[#1]

Hi Qv,

I have a expression like this Sum ({<$(vSegment) ={'3. Due Later'}>} Sales) and vSegment variable is working fine but the it showing syntax error at {'3. Due Later'}

what is the correct syntax to use variables contains the field names inside set analysis?

  thanx

[jyothish8807]

Hi Swathi,

How do want to use this variable?

baisic format is:

sum({$<[Field]={'$(=vSegment)'}>}Sales)

or are you trying to compare the text with in the variable?

Regards

KC

[jyothish8807]

Hi,

Try like this:

Var='ABC'

=if($(Var)='ABC',Sum(sales))

Regards

KC

[khasimvali85]

Hi Swathiraj,

                         can explain briefly i couldn't under stand, can send data in excel format.

I think 3.Due Later is Column name right? if it is column name use like this

=Sum({<3.Due Later={'$(=vSegment)'}>} Sales)

or

=Sum({<Due Later={'$(=vSegment)'}>} Sales)

Regards,

Khasim.