Expression in Straight Table

[bharatkishore]

Hi All,

I have 10 fields in a list box by writing an load * inline statement. I have written the below expression in the straight table chart

=sum(IB_1)

Now my problem is,this expression should be changed whenever i select a field(Flag) the expression should be changed to sum(IB).

If i un-select flag then it should be changed to sum(IB_1).

Attached qvw for reference.

Is it possible to achieve.

Thanks,

Bharat

[sunny_talwar · Accepted solution]

May be this

=If(SubStringCount('|' & Concat(distinct Dimension2, '|') & '|', '|Flag|'), Sum(IB), Sum(IB_1))

[mayankraoka]

Hi Bharat,

If I understand your requirement correctly here is the solution.

Please find attached qvw

Regards,

Mayank !

[bharatkishore]

Thanks Sunny....You are just Awesome...

One more thing after writing this expression based on the month selection the value should effect.

For example: if i select jan the value should be (expression)/1 , if  i select feb (expression)/2 , if i select march (expression)/3  if i april (expression)/4.. Can you please tell me how to achieve this..

[sunny_talwar]

May be this

=If(SubStringCount('|' & Concat(distinct Dimension2, '|') & '|', '|Flag|'), Sum(IB), Sum(IB_1))/Month(Period_NR)

[bharatkishore]

Thanks Genius.. Sorry Missed the trick..