1 Reply Latest reply on Jun 21, 2016 5:23 PM by Adam Crahen

    How to ignore a field while calculating Total ?

    zibal jafri

      Hello Everyone,

       

      I posted this question earlier but couldn't get the solution so far, so again posting it. I want to create a calculated field which should be the total of 'Percent'  for all the categories except for "DO Nothing".

      For Exmaple ; Chris's Total should be (38 + 50 +63 +75) and not  (20 + 38 + 50 +63 +75). The value for category "DO Nothing" should not be involved for calculating the Total..

       

      Pleas help me with this.

      Attached is the TWBX file for your reference

       

       

      Regards

      Zibal