Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculated calculation based on logic

Account Name Date Amount Rev 12-Jun-18 430 Exp 13-Aug-17 250 Margin 2-Mar-17 0 Rev 12 July 18 400 Exp 13-Aug-17 300   I have a table where I need to create a calcul...
ibarrau's avatar
ibarrau
Super User
7 years ago

Hi. Can you explain a bit more your idea? i don't understand why <> marin or = margin both result in sum of amount. The third line should something like: (i think variables can help to get better undestanding)

VAR amount_rev = CALCULATE ( 
    SUM (Table[Amount] ) ,
    Table[Name] = "Rev"
) 
VAR amount_exp = CALCULATE ( 
    SUM (Table[Amount] ) ,
    Table[Name] = "Exp"
)

RETURN
amount_rev - amount_exp

Hope this helps

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.