Forum Discussion

LotteLaugesen's avatar
LotteLaugesen
Icon for Helper V rankHelper V
4 years ago

Problem with running total

Hi    Can anybody tell me what's wrong with my running total? Why doesn't it aggregate when I have different Currency LCU? Can anybody tell me how to solve it? When I remove Currency LCU there is ...
needs help
LotteLaugesen's avatar
LotteLaugesen
Icon for Helper V rankHelper V
4 years ago

Hi tamerj1 

 

Thanks - It almost works 🙂

The first 2 lines are adding up, but below you can see that 2 other lines are not

Have you got any more other ideas?

 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

LotteLaugesen 

In this case use

ALLSELECTED ( TableNam[Currency LCU] ) inside the CALCULATE function.

  • LotteLaugesen's avatar
    LotteLaugesen
    Icon for Helper V rankHelper V
    4 years ago

    tamerj1 

    My calculation looks like this now, but it doesn't help 😞

     

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      4 years ago

      LotteLaugesen 

      please try

      Acc. DKK Amount =
VAR RT =
    IF (
        [DKK] <> BLANK (),
        CALCULATE (
            [DKK],
            ALLSELECTED ( FT_ARAP_Invoices ),
            REMOVEFILTERS ( 'Dim Calendar' ),
            'Dim Calendar'[Date] <= MAX ( 'Dim Calendar'[Date] )
        )
    )
RETURN
    RT
      • LotteLaugesen's avatar
        LotteLaugesen
        Icon for Helper V rankHelper V
        4 years ago

        tamerj1 thank you for your time, but it didn't make any difference.

        The final result is correct so right now I will go with this 😉