FDU_AMNT.FDU = Fee amount generated

FDU_CORD.FDU - Credit or Debit? (C or D)

SFU_CFEE.SFU = Expected Fee on Customer Record

 

The fee amount is always a positive number whether credit or debit and a customer may have multiple debits or credits or no credits. I want to sum FDU_AMNT.FDU where the FDU.CORD.FDU is C, sum them again where the FDU_CORD.FDU is D and then take away the total for C from the total for D but leave a positive number despite the figure being a debit. I then want to compare this total to SFU_CFEE.SFU and then only show records where these two figures don't match.

 

Thank you again for all your support, i am completely stumped!

 

Please let me know if you need any further information

 

This doesn't seem to work. I have setup a group of customer number, say 12345678 i have then placed the FDU_AMNT in the detail and the FDU_CORD. Customer 12345678 may have a debit record of 500, a credit record of 300 and another debit of 200. I want to be able to sum the debits giving me 700 at the group footer, sum the credits giving me 300 at the group footer then sum the debit minus credit giving me 400. I then want to compare this figure with SFU_CFEE and only display the records where this doesn't match.

 

thanks

(lets call it "Pos&Neg" for this example) formula field to sum, not the FDU_AMT field. .

 

convert it to a number first

call the formula "NumberCheck" (or whatever you want)

 

now us it in the other formula

maximum({@NumberCheck},{SRS_SFE.SFE_STUC}) = abs(sum({@Sum of CorD},{SRS_SFE.SFE_STUC}))