5 Replies Latest reply on Jun 12, 2014 10:38 AM by philmodjunk

    Allow user to over-ride a value not validation issue

    jbrogers1234

      Title

      Allow user to over-ride a value not validation issue

      Post

           I am trying to create a calculation that first looks to see if a numeric field (HrsOvr) is empty and if it is to calculate daily cost by using the numeric fields numhrs * costperhour, if the field HrsOvr is NOT empty replace numhrs with hrsovr and then calculate the new daily cost using the over-ride Over.

            

           DailyCost = 

           If( IsEmpty ( HrsOvr ); numHrs*costperhour ;HrsOvr*costperhour

            )