Comparing Numbers Question

[BrianDH]

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?

[BrianDH · Accepted solution]

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)