calculation issue

[#1]

I have below expression as calculation.

Sum({<Flag={'1'}>}Value) but when other value is selected from flag it should display the result for that.

[andrespa]

Hi, maybe you have a conceptual problem? That expression always give you back the result of having Flag=1 no matter what other value of Flag you select.

Best regards,

Andrés

[Anonymous]

Hi Chang,

You will always get the sum of selections of Value when Flag = 1, but if you want for every selections ever, you may use this Sum({1<Flag={'1'}>}Value)

Thanks!

[sunny_talwar]

May be this:

If(GetSelectedCount(Flag) = 0, Sum({<Flag={'1'}>}Value), Sum(Value))

[#5]

Let me clear it again.. current expression gives the value for Flag=1 but there could be other values too in Flag filed like 2,3,4. So when I select Flag=2 it should display value for Flag=2

Hope it is clear now

[Kushal_Chawda]

Not sure but may be this

Sum({<Flag *={'1'}>}Value)

[Anonymous]

Hi Chang Din,

There is two ways:

     Sum({<Flag={$(=Max(Flag))}>}Value) or Sum(Value)

Regards

[sasiparupudi1]

remove Flag from the set analysis and the sum should display values according to the value selected in the flag

Sum(Value).

Other option could be is to set a variable in input box

vFlag with values as 1,2,3,4,5

in the expression Sum({<Flag ={'$(vFlag)'}>}Value)

hth

Sasi