Forum Discussion

aldredd's avatar
aldredd
Icon for Advocate I rankAdvocate I
10 years ago
Solved

Calculations depending on value in column in related table

Hi guys, after a little guidance   two tables - one contains Transactions, the other Transaction Reasons (ParentReason and ChildReason)   Tables are matched on TransactionID on a 1-1 basis   ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    10 years ago

    hi aldredd

     

    AbsoluteExpenditure = If(RELATED(TransactionDescriptions[ParentReasons])<>"Income",Abs(BankTransactions[Value]),0)

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
10 years ago

hi aldredd

 

AbsoluteExpenditure = If(RELATED(TransactionDescriptions[ParentReasons])<>"Income",Abs(BankTransactions[Value]),0)

aldredd's avatar
aldredd
Icon for Advocate I rankAdvocate I
10 years ago

Thank you Vvelarde - I could swear I tried that and didn't work - must have made an error!

 

Works a treat, thank you