3 Replies Latest reply: Aug 19, 2014 12:31 PM by Ajay Krishnan Prabhakaran RSS

    Chart Expressions- if then else/ nested Ifs




      Am using the following script in an expression which is returning values as based on the conditions:-


      =sum(if((year(enquiry_award_loss_date)=YR and month(enquiry_award_loss_date)=Mth and (TeamStatus = 'Active') and (opheadm.status<9)and (Whiteboardexclusion<>'1'), if((opdetm.spare)>'0',opdetm.val/opdetm.spare,opdetm.val)))


        This works however, I need to add another  calculation changing the opdetm.val returned to a negative if the following field:- opheadm.Order_No like 'CN%' .

      Can anyone help?