"Total" doesn't work when there's an empty value within the rows

Questions & Answers
1

I’m tryin to add a Total to sum up rows where sometimes there’s empty value in it. Although I added CoalesceEmpty to the measure definition, it calculates 0 as Total (the separate empty lines are set to 0)

CoalesceEmpty( [Measures].[Logged by BillingRate] , 0 )

image

do you have any suggestion/workaround?

2

Hi @Zoltan_Durucsko,

The issue is likely that “Total” calculates separately from the row values. When using calculated measures with CoalesceEmpty, you may need to force the Total row to sum the results.

Try adding this annotation at the beginning of your formula:

-- annotations.total=sum
CoalesceEmpty( [Measures].[Logged by BillingRate] , 0 )

However, if “Logged by BillingRate” is a property rather than a measure, it won’t aggregate in totals at all. Properties don’t sum up automatically.

If this does not work, please send your report definition to support@eazybi.com so we can check your exact setup.

Best,
Marita from support@eazybi.com

3

Dear Marita,

thank you for your response, the suggested solution works (EazyBi calculates the Total this way)!

Best regards

Zotán

1 Like