1 Reply Latest reply: Mar 21, 2017 11:59 AM by Sunny Talwar RSS

    How do I get a Sum if to work using the Total Function

    Louisa Sizeland

      Hi there,

       

      I need to put in a KPI that is working out the % of a total amount of Customers but I need to use a sum if to select a fixed variable.

      The formula I have so far is as follows:

       

      sum(if([No. of Insertions]=1,(Customers)))/sum(if([No. of Insertions]=1,(Total Customers)))

       

      I am getting the error of : ')' Expected, but no matter where I try and put brackets, it doesn't seem to like the 'Total' being in there

       

      Can anyone help?

       

      Thank you