Forum Discussion

Silvermountain's avatar
Silvermountain
Frequent Visitor
3 years ago
Solved

Wrong column total

Hi all,   I've stumbled upon a problem that seems to occur regularly. I've found numerous topics that provide information about it, but it might be a topic too many because I didn't manage to find ...
  • Silvermountain's avatar
    Silvermountain
    3 years ago

    And sometimes you find the solution just 10 minutes later

     

    Nesting the calculate function in a SUMX did the trick.

     

    Forecast =
    sumx(col_area,
        CALCULATE(
            if([Opbrengst per gebied]=0, [Waarde van Gemiddelde bedrag per collectant]*[Aantal collectanten],[Gemiddeld bedrag per collectant]*[Aantal collectanten])
        )
    )
Silvermountain's avatar
Silvermountain
Frequent Visitor
3 years ago

And sometimes you find the solution just 10 minutes later

 

Nesting the calculate function in a SUMX did the trick.

 

Forecast =
sumx(col_area,
    CALCULATE(
        if([Opbrengst per gebied]=0, [Waarde van Gemiddelde bedrag per collectant]*[Aantal collectanten],[Gemiddeld bedrag per collectant]*[Aantal collectanten])
    )
)