Total Calculation algorythm / nexel

Maik Burghardt

Hi all,

anyone an idea how i can fix the total / grand total calculation?

You can see that i calculate the average per country however the calculation doesn't work on the Grand total line.

the expanded view looks like that 42 isn't recognized as a number.

any ideas?

thanks maik

Find more posts tagged with

Accepted answers

All comments

Helmut Heimann

Hi @Maik Burghardt ,

I think it's because the column calculates the total of an entity which is interpreted as text.

You could set up a block format and make the text alignment in the total of the column with the entities to be displayed "right".

Best,
Helmut

Maik Burghardt

Hi Helmut,

Would that text alignment give me the calculation on the grand total? meaning 2888 divided by 42?

Helmut Heimann

https://community.board.com/discussion/comment/19575#Comment_19575

the alignment only influences the display, not the value itself, so it should display and calculate correctly.

Helmut Heimann

Hi @Maik Burghardt ,

I think I misunderstood your problem: the value should be calculated as 2.888/42 (by the downtotal of the number of hotels), correct?

Then I'd suggest introducing a new (hidden) block with algorithm numeric, value 1, and then using the dt(<newBlock>) for the calculation in the total line.

Sorry for the misunderstanding.

Best,
Helmut

Helmut Heimann

Hi @Maik Burghardt ,

another question from my side: how do you calculate the averages—in Nexel?

If that's the case, the suggested downtotal algorithm will not work because Nexel is always the last action the system executes on a screen. In other words: a Nexel formula's result can not be used as input to an algorithm that is not Nexel.