Skip to content

    • Beast Mode

    Beast Mode

    BEAST MODE NOT WORKING AS EXPECTED

    Member
    in Beast Mode
    image.png

    BEAST MODE – AMOUNT LEFT

    CASE WHEN (IFNULL(`RevisedEstimatedCost`,0)) >= (IFNULL(case when `SourceCode` = 'AP' then `TransactionAmt` end,0))

    THEN (IFNULL(`RevisedEstimatedCost`,0)) - (IFNULL(case when `SourceCode` = 'AP' then `TransactionAmt` end,0))

    ELSE

    (IFNULL(case when `SourceCode` = 'AP' then `TransactionAmt` end,0)) - (IFNULL(case when `SourceCode` = 'AP' then `TransactionAmt` end,0))

    END

    Answers

    • Coach

      @jtrollinger Can you share some more details on what specifically isn't working and what values you're expecting? Also is your data aggregated?

    • Member

      Beast Mode AmountLeft is calculated based on the 1st Case Statement Where if RevisedEstimatedCost is >= TransactionAmt then it is to perform the first calculation if not then it is to perform the second. Yes Data is aggregated in a Group BY in ETL

      image.png

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories