Expression with Alternate State not working

[#1]

Hi,

In my Straight table chart I am using the following formula in the expression:

num(sum({$<Customer = p({[AltState1]}Customer)- p({[AltState2]} Customer)>}Sales),'$#,##0')

where I am trying to find out list of Customers slected in Alternate State AltState1 and not there in alternate state 2 AltState2.

and the Straight Table is in AltState1.

Whenever selection is made in AltState2 the values are not reflected.

Dimension used is: Customer

Thanks in advance!!

Regards,

Pooja

[tresesco]

Try this:

num(sum({<Customer = [AltState1]::Customer>- <Customer=[AltState2]::Customer>}Sales),'$#,##0')

[#3]

Thank you for your suggestion..

But this expression doesn't seem to work for me..

[tresesco]

It's working with me. Could you please share your sample app?

[jagan]

Hi,

Try like this

=num(sum({[AltState1]<Customer -= P({<Customer=[AltState2]::Customer>})>} Sales),'$#,##0')

Regards,

Jagan.

[#6]

Hi Jagan,

Thank You for your suggestion.

The problem I faced while using your expression was it gave an error at the p().

Regards,

Pooja

[jagan]

Hi,

I will show error but it works.  It is showing because -=.

Regards,

Jagan.

[#8]

Hi

PFA, Sample app.

Regards,

Pooja