I have two list boxes with separate alternate states ,
but i want to use these two states in a chart ,
=Sum({1 < [Scenario ID]={'A','A1','A2','A3','B','B1','B2','B3','C','C1','C2','C3'} , [Customer AR Data Scenario at YE]={'Positive Net AR'} , [100% Reserve Required based on Scoping]={'NO'} >}
[Cash Receipt])
- ( if(GetSelectedCount([Customer name])>=1,Sum({[Reserve Details Chart] < [Scenario ID]={'A','A1','A2','A3','B','B1','B2','B3','C','C1','C2','C3'} , [Customer AR Data Scenario at YE]={'Positive Net AR'} , [100% Reserve Required based on Scoping]={'NO'} >}
[Cash Receipt]),0))
- ( if(GetSelectedCount([GL Document Number])>=1,Sum({[KAAP reserve] < [Scenario ID]={'A','A1','A2','A3','B','B1','B2','B3','C','C1','C2','C3'} , [Customer AR Data Scenario at YE]={'Positive Net AR'} , [100% Reserve Required based on Scoping]={'NO'} >}
[Cash Receipt]),0))
i wanna exclude selection from those 2 alternate states ,[Reserve Details Chart],[KAAP reserve]