4 Replies Latest reply: Oct 16, 2012 6:34 AM by Nandor Santa RSS

    Subtotal is not addig all the rows when if clouse is prezent

      I used the following formula to calculate the data in a column. I have an if clouse and the Subtotal is skipping a number.

       

       

      =if(Tip_activitate='Rata lunara', sum(Rest_de_plata),

      RangeSum(Sum(Luni*PU_suplimentar_de_plata)

      +
      Sum(Marti*PU_suplimentar_de_plata)

      +
      Sum(Miercuri*PU_suplimentar_de_plata)

      +
      Sum(Joi*PU_suplimentar_de_plata)

      +
      Sum(Vineri*PU_suplimentar_de_plata)))

      I am attaching the qv file, please see column "Total costs"

       

      Another issue I don't understand, in column "Name" som records are missing in some rows.

       

      Thank you,