Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have a 'Rejection Status' field that contains two values only; 1) Accepted 2) Rejected
I would like to ignore all 'Rejected' values in an expression until it is explicitly selected in the list box.
Scenarios
1) Nothing selected in 'Rejection Status' - Sum([Net Order Value]) for Accepted lines only
2) 'Accepted' selected in 'Rejection Status' - Sum([Net Order Value]) for Accepted lines only (same as 1)
3) 'Rejected' selected in 'Rejection Status' - Sum([Net Order Value]) for Rejected lines only
4) Everything selected in 'Rejection Status' - Sum([Net Order Value]) for all lines
Can set analysis handle this?
Thanks
Maybe like
=Concat({<Status *= {'$(=If(GetSelectedCount(Status),'*','Accepted'))'}>} Status)