total function

[thewillemzelluf]

Hello everyone,

I have a question about the totals function. In the table (left in the image) the totals function is set to automatic. The sum of these amounts is 0.31653 ....

However, if I use the same calculation for the kpi graph, a different outcome will emerge. Any idea how I get the same result in both graphs?

The calculation used is:

=SUM(IF([Order registratiedatum] - Partijdatum > Gewenst, [Totaal geleverd], 0)) / SUM([Totaal geleverd])

Thanks in advance!

[swuehl]

Does your dimension(s) in your chart show NULL in some of the records?

edit:

What if you make an active selection of all possible values in your dimension field? Do both charts show the same total now?

[thewillemzelluf]

oh i see it, when i include null values i get the same value. any idea how to exclude null values in my KPI chart?

[swuehl · Accepted solution]

Try a set expression that selects all possible values in your dimension field:

=SUM({<YourChartDimensionField = {"*"}>} IF([Order registratiedatum] - Partijdatum > Gewenst, [Totaal geleverd], 0))

/ SUM({<YourChartDimensionField = {"*"}>} [Totaal geleverd])

[thewillemzelluf]

thankyou! it did work out!