Recalculate totals without hidden fields...?

[mhkbdk]

Can ReportNet re-calculate totals and sub-totals WITHOUT hidden fields?

For example, I’m trying to generate a report based on income levels but my data has a lot of “unknown”. The “unknown” data completely throws off the % calculations and any charts I try to create.

Is this something my admin needs to set up?

Any advice would be greatly appreciated.

Thanks,
-Mike

 

[blom0344]

What do you mean by 'unknown'? Null values?
Or are null values substituted by a default 'unknown' string.
Did you attempt to filter them from the resultset?

Ties Blom

 

[mhkbdk]

Thanks Ties,
My example of “unknowns” was probably not the best one to use. We are working on filtering them out beforehand but that will only partially solve the problem.

There are several instances where I would like to eliminate some data and recalculate all of the percentages. Unfortunately, I can only hide a column but the totals and, therefore, percentages don’t change.

Thanks for your help.
-Mike

 

[blom0344]

You can set a filter that performs prior to aggregation (a condition in the where clause of the query) and one that performs the filtering on the resultset (after aggregation)
Did you check whether that can be used?

Ties Blom