Forum Discussion

steff131284's avatar
steff131284
Frequent Visitor
5 years ago
Solved

Reference to Sum Value

Hi,

 

quick question.

 

I have a data set with different "Delta" positions and one total output. 

I now want to reference each of the variance categories to the total output. In Excel this would be easy by using the $ sign.

How do I need to change my formular?
Right now it is 

Delta MA Quote = [Delta MA in €]/[Gesamtleistung Ist]    but this only works for the Total and not the single categories?
 
Best regards
Stefan
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    steff131284 

    Modify the formula to one of these:

    Delta MA Quote = 
DIVIDE (
    [Delta MA in €],
    CALCULATE (
        [Gesamtleistung Ist],
        ALLSELECTED ( Table[Variance])
    )
) 
    Delta MA Quote = 
DIVIDE (
    [Delta MA in €],
    CALCULATE (
        [Gesamtleistung Ist],
        ALLSELECTED ()
    )
)

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    steff131284 , Not very cleat. It is working. but you do not have value for Gesamtleistung Ist

     

    better version

    Delta MA Quote = divide( [Delta MA in €],[Gesamtleistung Ist])

     

    or

     

    Delta MA Quote = divide( [Delta MA in €],[Gesamtleistung Ist],0)

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    steff131284 

    Modify the formula to one of these:

    Delta MA Quote = 
DIVIDE (
    [Delta MA in €],
    CALCULATE (
        [Gesamtleistung Ist],
        ALLSELECTED ( Table[Variance])
    )
) 
    Delta MA Quote = 
DIVIDE (
    [Delta MA in €],
    CALCULATE (
        [Gesamtleistung Ist],
        ALLSELECTED ()
    )
)