1 Reply Latest reply: Oct 29, 2015 2:15 PM by Stefan Wühl RSS

    Set Analysis - Ignore field value until explicitly selected

    James Green

      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