Hi,
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]
