Sums in a Report

Topic

New Reply

Hi!

I have a report that has control [timelysynchtooffice] which will have results of either “Timely Submission” or “Late Submission”. There is a corresponding control [sumoftotal] that gives the numeric result for each of the above. The report has a MATUser header and footer and MATDOC header. I need to be able to break out the Sum for “Timely Submission” and “Late Submission” not just the total sum for [sumoftotal]. I’ve tried a variety of conditional statements but so far nothing is going me what I need.

Thanks,
Leesha

Reply | Quote

Replies

To get the sum for “Timely Submission”:

=-Sum(([timelysynchtooffice]=”Timely Submission”)*[sumoftotal])

or

=Sum(IIf([timelysynchtooffice]=”Timely Submission”,[sumoftotal],0))

Similar for “Late Submission”.

Reply | Quote

Thanks! That is what I needed!! Now I can see why I was getting zeros.

Leesha

Reply | Quote