5 Replies Latest reply on Jun 25, 2016 10:27 AM by alangodfrey

    calculation on summary field.

    malachydevlin

      Im sort of beat on this one but I have a summary group in a report (with a summary field) that is a RUNNING TOTAL>

       

      so its a total_sales.

      I wanted to display a calculation field instead of the real value that shows:

      "Between 10t and 20t"

      "Between 20t and 30t"

       

      the client doesn't want to see real values, but banded values.

       

      The calculation can't seem to pickup the grouped summary field per group and just gives odd results.

      Im using a let function with case to band the values.

       

      any help?