Consolidated Sum and Average on reports

Questions & Answers
1

Hello !

We have a report with information regarding project such as budget, actual, % of budget spent etc…

I am trying to the information consolidated for each of the columns.
But sometimes we should have sum, and sometime new % based on the sums.

image
image1890×753 75.2 KB

In green, this is fine, in red this is not what we want :slight_smile:

Is there any way to implement such calculations based on total of columns ?

Thanks a lot for your advice.

2

@pchampet
What formula do you use to calculate the measure “Budget Total Consomme %” in your current report?

Martins / eazyBI

3

Hello @martins.vanags

We use the following formula:

--annotations.group=Project-Factsheet
CASE WHEN
 [Measures].[Budget Annuel Projet] = 0
THEN
[Measures].[Consommé annuel à date] / 0.1
ELSE
[Measures].[Consommé annuel à date] / [Measures].[Budget Annuel Projet]
END
4

@pchampet
And what formula to do you use to define “Consommé annuel à date” measure?

Martins

5

I come back to this one… sorry for the delay.

This “Consommé Annuel à date” is a formula that is only a proxy to a Projectrack fields where the actual budget is stored.

6

@pchampet
Unfortunately, there are no “cheats” to hide the total sum just for some of the measures in columns when the “Total” feature is enabled…

One workaround would set the specific value on the total row for some of the measures but it won’t be completely empty then.

Martins / eazyBI

1 Like