2 Replies Latest reply on Oct 14, 2015 12:06 AM by disabled_kylerjphillips

    Calculating 3 results/outcomes (Accepted, Outstanding and Withdrawn)

      I have an unstored calculation field Requests::cRequest Status - the calculation for this is as follows:

       

      If ( GetAsBoolean ( Staff Requests Join::__fkAgencyId ) = 1  ; "Accepted" ; "Outstanding")

       

      So basically, when there is a Staff Requests join record that has a __fkAgencyId associated with it - the status is Accepted and when there isn't the status is Outstanding.

       

      I also want another Request Status which is withdrawn, I wan't this to be calculated when Requests::RequestsWithdrawn = "1" how can I add this into my current calculation, almost as an overriding factor? So almost as if regardless if the requests has a join record or not, the calculation is "Withdrawn" if the field equals "1".