Sum fields in Formula

[cothmer]

Is there a way to sum 3 fields in a formula ? It works for 2 of them but I added a third and now I get this message.

[ido_millet · Accepted solution]

Option 1: Add A + B in a formula and SUM that formula at the desired grouping level.

Options 2: Add the SUM formulas.

Option 1 has a couple of advantages.

[ido_millet]

The 2nd argument in the SUM() is the Grouping level, NOT a 2nd item to be summed.

If you need to add 3 elements, simply use A + B + C.

[cothmer]

Thanks. However, I tried the first one and got this message, the second one didn't work either.

[DellSC]

There are a couple of ways you could do this:

Sum({@On Time?} + {@On Time? 2}, {@Clinician Name and ID})

or

Sum({@OnTime?}, {@Clinician Name and ID}) + Sum({@On Time? 2}, {@Clinician Name and ID})

-Dell

[cothmer]

So Clinician Name and ID is the group and I want to add @OnTime and @OnTime 2 together and get the total for that group. How would I write this ? Thanks.