crystalnewbie
MIS
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?
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?