Skip to Content
0
Jan 26, 2023 at 04:23 PM

this field cannot be summarized crystal reports

47 Views Last edit Jan 26, 2023 at 04:25 PM 2 rev

Two separate formula's (Main Report and there's no sub report)

Step 1:

Formula A = {table1.amount}

Formula B = {table1.margin} * {table1.quantity}

Step 2:

sum(formula A)

sum(formula B)

Step 3:

Sum A & Sum B placed in the Group Header and Group Footer.

Step 4:

Percentage = (Summary B / Summary A * 100) is placed in the Group Header

until step 4 it's working fine.

Step 5:

Want to sum / total the Percentage column and place the value in Group Footer. Please advise how to overcome the issue.

image.png

Attachments

image.png (30.0 kB)