locked
Needing to make revenue positive based on value RRS feed

  • Question

  • Hi,

    In PowerPivot I am bringing all my transactions into one table (Transactions) but am needing to turn all transactions with certain codes into a positive number.

    I have another table called (LINK CODES) with the codes listed next to heading ie Revenue.

    I want to say in the calculated column if that code is on the same row as 'Revenue' then make a positive number.

    Thanks for help.

    Wednesday, July 13, 2016 9:20 AM

Answers

  • Solved!

    =IF(RELATED('LINK CODES'[Heading])="Revenue","yay","nay")

    • Proposed as answer by Olaf HelperMVP Wednesday, July 13, 2016 10:42 AM
    • Marked as answer by Charlie Liao Sunday, July 24, 2016 2:45 AM
    Wednesday, July 13, 2016 10:29 AM

All replies

  • SORT OF LIKE 

    =IF(RELATED([posting_code],'LINK CODES'[Code] = "Revenue"),[journal_amount],[journal_amount]*-1)

    Except that is saying it related can only have one argument.

    Thanks


    • Edited by JaK82 Wednesday, July 13, 2016 9:30 AM
    Wednesday, July 13, 2016 9:30 AM
  • Solved!

    =IF(RELATED('LINK CODES'[Heading])="Revenue","yay","nay")

    • Proposed as answer by Olaf HelperMVP Wednesday, July 13, 2016 10:42 AM
    • Marked as answer by Charlie Liao Sunday, July 24, 2016 2:45 AM
    Wednesday, July 13, 2016 10:29 AM