Expression understanding

[#1]

Hi All,

Alternate sets  G , B defined in a dash board.

One Bar Chart defined with dimensions A -->This is field item and  ValueList('G','B') -->This is Calculated dimension where G , B are not field items.

Expression is as follows.

if(ValueList('G','B') = 'G',Avg({G}C),if(ValueList('G','B') = 'B',Avg({B}C))) ---> Here C is field item.

I would like to know what is happening with above expression.

Could anybody help on this?

Thanks.

[lironbaram]

by using the value list

in one expression

you use to different sets of data

G,B are alternate states which mean are two different set of the data the selection on each set doesn't effect the other

[sunny_talwar]

This expression seems to be comparing the Avg(C) based on different selections in two states. Have you tried to build the scenario to see what it is doing? I think the best way to understand what an expression is doing it to make a small application and see what happens when you make selections.

[#4]

Thank you all