I have a formula that subtracts one formula from another formula on the group footer. One is a summed total the other is a field multiplied by a number. If the summed total formula has only one record in it, it is correct, if more then one record it’s not correct.
C1 C2 C3
Ying 75
GF1 75 300 -225 (75-300=-225)
Yang 224
224
224
224
224
GF1 1120 896 -672 (1120-896=224)
C1 formula is, @TrandAmount, which is {U4TRND.TDAMT} * -1
C2 formula is, @Required Payments, which is {U4CSTMR.CSBGPY} * 4
C3 formula is, @DIFF, which is {@TrandAmount} - {@Required Payments}
This is my first post here so I hope I’ve included all the info that’s required to help solve this problem I’m having.
Thanks