Divide by - Function

Benjamin Fronius
Benjamin Fronius Customer
Level 200: Building A Planning Solution in Board Name Dropper Level 100: Foundations of Building in Board First Anniversary
in Platform

Hi there I have an strange issue:
In the following i want to divide the values by 1000.
But Board is actually dividing by 100.000:

MicrosoftTeams-image.png
MicrosoftTeams-image (1).png

Answers

  • Philipp Schumacher
    Philipp Schumacher Employee
    Fourth Anniversary 25 Likes 5 Answers 10 Comments

    Hi Benjamin,

    I cannot reproduce your case, maybe you can give a bit more information about the layout and the display settings you made on the Object?

    One thing i recognized in your screenshot is, that you display the cumulated values from block b, but you apply the scaling to the values of block a?

    Kind regards

    Philipp

  • Benjamin Fronius
    Benjamin Fronius Customer
    Level 200: Building A Planning Solution in Board Name Dropper Level 100: Foundations of Building in Board First Anniversary

    Hi Philipp,

    thanks for your quick answer.
    Exactly i would like to show the cumulative sales. But i have built in an if-function, so that the chart won't show the same value for the future months.

    There are no further settings made in the object.

    Even though i apply the divide by funtion direct on block a it divides the values not with 1.000 but 1.000.000

    image.png

    I think board has a problem with the ranking function.

  • Benjamin Fronius
    Benjamin Fronius Customer
    Level 200: Building A Planning Solution in Board Name Dropper Level 100: Foundations of Building in Board First Anniversary
    edited March 2023

    It looks like the divide by function doesn't work on ranking blocks…

  • Dietmar Jeschkeit
    Dietmar Jeschkeit Active Partner
    Fourth Anniversary 100 Comments 25 Up Votes 25 Likes

    Hi Benjamin,

    you are right. The function doesn't seem to cope with the divide by at the source block.

    An alternative is to do this via an algorithm and have the ranking function accumulate this.

    image.png

    Kind regards

    Dietmar

  • Dietmar Jeschkeit
    Dietmar Jeschkeit Active Partner
    Fourth Anniversary 100 Comments 25 Up Votes 25 Likes

    Or include the divide by 1000 in the algorithm of c.

Categories