3 Replies Latest reply on Aug 24, 2016 3:17 AM by Swarnalatha Mannar Mannan


    Siva raja

      I have a calculated field say

      IF ATTR(DATEDIFF('day',[Date1],[Date2])) <=1

      THEN "Efficient" ELSE "Inefficient" END


      Now i need to calculated all inefficient and show it in percentage.


      Concept = inefficient of particular branch/ inefficient of all branches(total inefficient).
      Please help me