Problem: The sheet has a calculated field named 'Average % Delta' and the field is required at date level.
On using the average function to figure out the average value of the calculated field, it throws an error. (an aggregate function cannot be aggregated further)
Is there any way around this error?
The calculations should hold for multiple selections in the filter too.
Similar error repeats while trying to find the standard deviation too.
4 answers
Hi,
- The calculations you have created are missing measures eg. below
- So you can add the field in the calculation and remove the "SUM" so the field will look like
[control active]/[Control Base] here you will get you calculation for Control % Transactors
- Similarly you do the same for "Test % Transactors " ie. ([test actives])/([Test Base])
- Now you will not get an error for the StdDev and Average % Delta fields
Hope this helps solve your problem.
Regards,
Alvino Vaz
