formula

[thorny00]

I new at this CR formula stuff so please bear with me.
Basically I want to do the following:
SUM {mtgterms.loanamt}, {codes.prodd} when {codes.appstatn = 'Y'

ie
sum the loanamt for each prodd when the appstatn equals Y

Thanks in advance for all the help!

 

[synapsevampire]

Create a Running Total (Insert->Field Object->Right click Running Totals and Select New) on:

{mtgterms.loanamt}

Reset at

{codes.prodd}

and in evaluate use a formula place the criteria:

{codes.appstatn} = 'Y'

-k

 

[lbass]

Or you could create a formula:

if {codes.appstatn} = 'Y' then {mtgterms.loanamt} else 0

Then insert a sum on this at the group level.

-LB