Issue with Drilldown Report when Parent Report Contains a Calculated Column

Question

I'm having an issue with my Drilldown Report showing no records when my Parent Summary Report contains a Calculated Column. The Parent Summary Report indicates a qty of items exist for a particular row/column, but when the link is clicked the embedded drilldown report shows no records.

I believe the problem is related to the Calculated Column in the Parent Report. The Calculated Column in the Parent Report is used as a filter and that filter is passed down to the Drilldown Report. However, the Calculated Column formula is NOT passed down to the embedded Drilldown Report, so Calculated Column is undefined in the filter.

Has anyone else seen this issue and is there a fix?

quickbasecoachd · Answer

no problem.&nbsp; I hate calculated columns. Make a real field.

garyguilbeaux · Answer

Yes, thanks.&nbsp; That does work and it does solve the problem.&nbsp; Of course, a more elegant solution would be for the Quickbase team to properly pass down the Calculated Column formula to the Drilldown report.

vedprasad · Answer

Is this fixed?------------------------------Ved Prasad------------------------------

Forum Discussion

Issue with Drilldown Report when Parent Report Contains a Calculated Column

3 Replies

Related Content

Calculating 1.5 pay

Calculation/Performance Limits Inquiry

How to Calculate Completion Percentage Using Multi-Select Boxes

Calculating number of days between two date fields

Trying to calculate On Time delivery