I have a report that summarizes by date, which works fine, but I now need it to sum by "county-(where the goods came from)" before summing by date and need to figure out how to do that
In the detail line I have the following formula field "PADEP_MUN"
if {IPDETAIL.WCLASS} = '01' then Round({@Tons},4) else 0
In my group footer, I have the following formula field "L_PADEP_TOT_MUN"
ROUND(SUM({@PADEP_MUN}, {INBOUND.DATE},"monthly"), 1)
There is already an existing group header of INBOUND.DATE