Problem with derived field based on group footer summary

[crystalnewbie]

I'm trying to create a derived field that subtracts the value of a summary field in the group footer with a non-summary derived field also in the group footer.

I have a derived field ClaimsPaid:
ClaimsPaid = abs(DECODE "PS_AL_CHK_DED"."AL_DEDCD", 970, "PS_AL_CHK_DED"."AL_AMOUNT, 980, "PS_AL_CHK_DED"."AL_AMOUNT, 0)

that I'm using to subtract to the sum of the "PS_FSA_BENEFIT_VW.ANNUAL_PLEDGE" column, to create another derived field called AcctBalance like shown below:
AcctBalance = PS_FSA_BENEFIT_VW."ANNUAL_PLEDGE" - ClaimsPaid

I'm not getting the correct result. I think what I need is to refer to the summary field that I created for Annual_Pledge. I just don't know how to refer (syntax) to it, to use in my AcctBalance derived field. What is the syntax to do that?

 

[cabbey77]

AS far as I am aware, it is not possible to calculate from another SQL derived field unless you use a Macro.