Average Down Total

Matthew Sobon
Matthew Sobon Customer
Second Anniversary 10 Comments Level 100: Foundations of Building in Board 5 Up Votes
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, Community Captain
    Fourth Anniversary 5 Answers 10 Comments 5 Likes

    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