Average Down Total

Options
Matthew Sobon
Matthew Sobon Customer
Level 100: Foundations of Building in Board First Anniversary 5 Up Votes Photogenic
in Platform

Hello,

I have run into an issue where Board seems to be ignoring the 0 values when calculating the down total when I have the summary set to "Average". Is this an issue with my data load?

image.png


Answers

  • Bart Scott
    Bart Scott Active Partner
    5 Likes Photogenic Community Captain First Anniversary
    Options

    Are the values zero, or are they null? Turn off display zeros and check if they are null (missing). It may be only including members with an actual value in the Average calculation. If that is the case you could try to do an expression against the block that replaces missing values with zero, although that would possibly show all members of the entity (which then you could potentially do a filter to remove any members that are completely zero across the row).


    Bart Scott

    CFO Solutions LLC

Categories