1 Reply Latest reply on Feb 25, 2016 4:20 PM by Esther Aller

    Wrong calculation of subtotal for a created calculated fields

    Jonathan Velarde

      Hi Mam/Sir..,

      Good Day!

       

      Would like to seek your assistance as I encountering a problem regarding with my report.

      I created calculated fields based on the requirement needed by my user and I want to display the subtotal per store of each calculated field.

       

      Please see attached file for the sample output of my report.

      Total in the last column displays the right figure. But from PD current to PD 120 over, the Subtotal displays wrong value.

      I also noticed that those calculated fields that displays the wrong values cannot use the total using SUM.

       

      I just need to calculate those fields as sum but i can't find any ways.

      Hopefully someone could help on this.

       

      Thanks and God Bless

      Jonathan B. Velarde