Divide by - Function

Options
Benjamin Fronius
Benjamin Fronius Customer
Level 100: Foundations of Building in Board First Anniversary First Comment
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
    First Anniversary Level 100: Foundations of Building in Board Level 200: Leveraging Board for Business Insights 5 Likes
    Options

    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 100: Foundations of Building in Board First Anniversary First Comment
    Options

    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 100: Foundations of Building in Board First Anniversary First Comment
    edited March 2023
    Options

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

  • Dietmar Jeschkeit
    Dietmar Jeschkeit Active Partner
    First Anniversary Level 100: Foundations of Building in Board First Comment 5 Up Votes
    Options

    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
    First Anniversary Level 100: Foundations of Building in Board First Comment 5 Up Votes
    Options

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

Categories