How to do create newField from other field in GroupHeader or GroupFooter?

[MMAASS]

Hi!

I need grouped data in my Report and show summarize in GroupHeader Or GroupFooter.
Sum(Field1) & Sum(Field2)

And calculate newField from Sum(Field1) & Sum(Field2).

so:

If Sum(Field1) = 0 Then
newField = Sum(Field2)
Else If Sum(Field2) = 0 Then
newField = Sum(Field1)
Else
newField = Sum(Field1) / Sum(Field2)
End If


How to do create newField that show in all groups?

[Edward]

Hi

You can use IIF function and Totals for this as you can see it in the attached report. Please open it in the Demo.exe sample application from the standard installation.

Thank you.

[MMAASS]

Hi.
Thank you for answer.

I can't use IIF. Because I have more one conditions and IIF use for one condition. I use Switch structure And resolve my problem.

[Edward]

Hi

Please let us know if any help is required.

Thank you.