Field not showing up

[kchaudhry]

I am using CR 8.5 with SQL 2000 backend. I have a formula which matches one record in the entire database. My problem is that when I put that formula field in the group footer it shows me "0". If I place this formula in the details section then I get the correct value.

I have to get this value in the group footer. Any ideas how I can do that?

Thanks in advance.

Kchaudhry

 

[lbass]

Try inserting a maximum on the formula in the detail section. If this doesn't work, please share the formula.

-LB

 

[nagornyi]

In the group footer the formula works on the last value in the detail section. You may create another formula that assumes max value (for the group, if needed) of the first formula and place it to the footer.

 

[kchaudhry]

I am not sure how to insert a max value. Here is my formula:

if {formula.formula} = "Productivity Commission/Team Pool"
then {formula.compensation_total}

Can someone please guide me how to insert a max value on this?

Thanks

Kchaudhry

 

[kchaudhry]

I was able to get the data to show up in the group footer using the max value. Here is the formula that I created:

Maximum ({@PoolBonus},{Participant.id})

Thanks for putting me in the right direction.

Kchaudhry