4 Replies Latest reply: Dec 11, 2012 10:25 AM by David Nelson RSS

    Conditional Calculated Value in Table Chart Column?

      (I have searched for this answer but have not found anything applicable to my situation.) I have a column in a table chart whose values should only be calculated if their status is "Submitted", "Resubmitted" or "In Approval"; otherwise it should display a null value. Can someone help me understand the proper syntax required for this and in which field I need to place it? This is as far as I've gotten with the expression guessing and obviously it's not working:

       

      =if({status_name='Submitted','Resubmitted','In Approval'}, (num(((today()+1)-submit_date),'#,##0.00')),1,0)
      

       

      Thanks in advance.