You won't be able to summarise that field directly as it is a text calc. You will have to run your summaries on the underlying number fields and then use this field to construct your report—sort by it and place it only on the sub summary part in order to group the report.
thanks, yes however the calculation on the underlying number fields will also be a text result and there would be no way of summing these up in a group.
if i have 2 values
1 to 2m
4 to 6m
there would be no way i could total that to 5m to 8m.
Maybe I'm missing something... if you post your original calculation it would help... but maybe this is what you're looking for:
Let ( [
~total = GetSummary ( RunningTotalField ; SummaryGroupField )
~total < 10 ;
"Less than 10t" ;
~total < 20 ;
"Between 10t and 20t" ;
~total < 30 ;
"Between 20t and 30t" ;
"30t or more"
sorry but the GEtSummary refuses to show the total as it restarts at each group, it shows the running total.
Whereas, the report restarts the total at each instance.
I may have to get some complex relationship to work this out before summarising it.
To better understand your question (I'm not sure if you want running totals or restarting totals, or what exactly you are 'summing'), can you say what does this file not do that you want it to do?
BandedTotal.fmp12.zip 65.9 K