Grand Total 1

[dawtes]

Hi,
Can you help me out on how to find the Grand total of this formula.
if GroupName ({table_name.field_name}) = 'A' then
(67.7 * Count ({table_name.field_name}, {table_name.field_name}))/100
else if GroupName ({table_name.field_name}) = 'B' then
(37.8 * Count ({table_name.field_name}, {table_name.field_name})) / 100
else if GroupName ({table_name.field_name}) = 'C' then
(15 * Count ({table_name.field_name}, {table_name.field_name})) / 100
else if GroupName ({table_name.field_name}) = 'D' then
(53.8 * Count ({table_name.field_name}, {table_name.field_name})) / 100

Thank you

 

[lbass]

You don't need to use groupname in the formula, you can just use the group field itself. Create two formulas:

//{@accum} to be placed in the group header or footer:
whileprintingrecords;
numbervar grtot := grtot + {@yourformula};

//{@display} to be placed in the report footer:
whileprintingrecords;
numbervar grtot;

-LB

 

[dawtes]

Thank you, I got it working