Total Calculation algorythm / nexel

Maik Burghardt
Maik Burghardt Customer
10 Comments First Answer 5 Likes First Anniversary
in Platform

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.

image.png

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

image.png

any ideas?

thanks maik

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary
    edited January 28

    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
    Maik Burghardt Customer
    10 Comments First Answer 5 Likes First Anniversary

    Hi Helmut,

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

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary
    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
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    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
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    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.

    Best,
    Helmut

  • Maik Burghardt
    Maik Burghardt Customer
    10 Comments First Answer 5 Likes First Anniversary

    So what I am basically doing is:

    I Calculate with the algorythm the subtotals (average by country).

    With the Nexel i distribute the individual hotel number into the column of the subtotal.

    image.png

    However that doesn't work on the (grand) total level.

    image.png

    I mean it would be simple if I could say that where it says BRUMT (in the first screen shot) treat that as a 1. But that doesn't seem to work.

    Or in other words: i want column C and D numbers in one column.

    image.png
  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    Hi @Maik Burghardt ,

    I think you might be looking for something like this

    image.png

    Here's the layout

    image.png

    Block gives the average per product group,

    image.png

    block c is the downtotal of b, used for further calculation in block d. You can hide b and c and name d a bit more appropriately.

    Best,
    Helmut

  • Maik Burghardt
    Maik Burghardt Customer
    10 Comments First Answer 5 Likes First Anniversary

    I found a different way to manage it.

    Your example still had the challenge showing the correct Grand total.

    Thank you for looking into this.

Categories