Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Inverse Running Total

I am attempting to calculate an inverse running total on values. So I would in essence start with a value, 100, and in an indexed format reduce that value based on the next indexed field.    Exampl...
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago
    Running Diff = 
MINX( FILTER( INFO, INFO[Index] = 1 ), INFO[Value] )
    - SUMX(
        FILTER( INFO, 1 < INFO[Index] && INFO[Index] <= EARLIER( INFO[Index] ) ),
        INFO[Value]
    )

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago
Running Diff = 
MINX( FILTER( INFO, INFO[Index] = 1 ), INFO[Value] )
    - SUMX(
        FILTER( INFO, 1 < INFO[Index] && INFO[Index] <= EARLIER( INFO[Index] ) ),
        INFO[Value]
    )

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    This solved my needs, thank you very much!