Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Team
I am trying to show only records where my CAP amount is not equal to my Spend Amount however I am getting a record where the amounts are the same, as far as I can tell (See Image).
Aggr(if(Sum(B_BH_AMOUNT_CAP) <> SUM(B_BH_AMOUNT_ACT + B_BH_AMOUNT_PAY + B_BH_AMOUNT_GLA +B_BH_AMOUNT_GLL +B_BH_AMOUNT_GLQ +B_BH_AMOUNT_GLR +B_BH_AMOUNT_GLE +B_BH_AMOUNT_OTHER)
,MasterKey),MasterKey)
Suggestions?
Resolved Trim()
Aggr(if(Sum(B_BH_AMOUNT_CAP) <> Trim(SUM(B_BH_AMOUNT_ACT + B_BH_AMOUNT_PAY + B_BH_AMOUNT_GLA +B_BH_AMOUNT_GLL +B_BH_AMOUNT_GLQ +B_BH_AMOUNT_GLR +B_BH_AMOUNT_GLE +B_BH_AMOUNT_OTHER))
,MasterKey),MasterKey)
Resolved Trim()
Aggr(if(Sum(B_BH_AMOUNT_CAP) <> Trim(SUM(B_BH_AMOUNT_ACT + B_BH_AMOUNT_PAY + B_BH_AMOUNT_GLA +B_BH_AMOUNT_GLL +B_BH_AMOUNT_GLQ +B_BH_AMOUNT_GLR +B_BH_AMOUNT_GLE +B_BH_AMOUNT_OTHER))
,MasterKey),MasterKey)