text in group footers

[teachmecr]

Hi
how can i have group footers with different texts in it. for example i have 2 groups with different headers but for each group footer where im summing i wana be able to insert different text such as sales total and paydowns total. The problem is that it shows it in both group footers. thanks

 

[lbass]

Create a formula like this:

if {table.groupfield} = "Sales" then "Sales Total" else
if {table.groupfield} = "Paydowns" then "Paydowns Total"

Use this instead of a text box.

-LB