Hi There,
I’m trying to create a field using a formula that takes GL Actuals - GL Budget. Here is my formula but its not giving me the right numbers...
=IIf( ( (Account.Type] = 'I' and dglhistory.balancetype] = 'A' ), ,GLHistory.CuryFinPtdCredit] - -GLHistory.CuryFinPtdDebit],0) - IIf( ( (Account.Type] = 'I' and dglhistory.balancetype] = 'B' ), ,GLHistory.CuryFinPtdCredit] - -GLHistory.CuryFinPtdDebit], 0 )
I also want to nest in for account.type = ’E’ when debits and credits are reversed but was trying to get this to work first. All my other numbers are fine...just this variance field that is off.