is there a way to remove the last line of total and average.I also want to eliminate 0 if shown in a report

Question

quickbasecoachd · Answer

I assume that you mean on table reports? The feature of it a column shows totals or averages is set on each of the field's field properties on the report.

As for the zeros, are these summary totals showing off a relationship? If so, then you can adjust the summary fields to not include children with zero values.

kristywilliford · Answer

Hi mark the second solution worked like a charm.But the first one is complicated.As I do not want the totals on the whole.Because logically there is no 300%&nbsp;

quickbasecoachd · Answer

If you have a field for a percentage, you know that it does not make sense to total but Quick Base does not.&nbsp; So adjust he field properties for that field and tell it not to show totals (uncheck the box).

kristywilliford · Answer

hi mark thank you.I am looking for a report to be displayed like this.Is this achievable

quickbasecoachd · Answer

OK, so you need the totals but you want to suppress the Grand Totals, so the line with 448 in your screen shot.&nbsp; No I think that you either get all Subtotals and Grand Totals or no Totals at all.

Forum Discussion

is there a way to remove the last line of total and average.I also want to eliminate 0 if shown in a report

Related Content

Removing \r\n from field

Pipeline to remove file attachments

Eliminating characters from a Text Feild

Sum Overlapping Time/Remove Timeframe Gaps

Exchange Templates Removed?