AnsweredAssumed Answered

calculation on summary field.

Question asked by malachydevlin on Jun 25, 2016
Latest reply on Jun 25, 2016 by alangodfrey

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?

Outcomes