Thank you in advance for any advice.

I am trying to calculate the average of one field based on the value of another, and would like to make these formulas work and not use running totals (as this is only one part of a much larger calculation).

The field I would like to average is: {Sheet1_.Arguing}
It is a number field with values 1-5.

The field that I would like to use as the condition is: {Sheet1_.Time}
This can have the values: "Intake", "Annual", and "Discharge".

I want to calculate the average of {Sheet1_.Arguing} separately for when {Sheet1_.Time}="Intake" and {Sheet1_.Time}="Discharge"

In order to use the average(field,condfld) i created two booleans to evaluate true depending on if {Sheet1_.Time}="Intake" or "Discharge".
@Intake_True: {Sheet1_.Time}="Intake"
@Discharge_True: {Sheet1_.Time}="Discharge"

Then made the formulas:
average({Sheet1_.Arguing},{@Discharge_True})
average({Sheet1_.Arguing},{@Intake_True})

Both booleans work accurately.

Only the average({Sheet1_.Arguing},{@Intake_True}) works.

average({Sheet1_.Arguing},{@Discharge_True}) returns the same value as when evaluating for {@Intake_True}.

Thank you SO much for your help. :)

Thank you for responding!

I made sure to have a group for each of my boolean formulas:
@Intake_True and @Discharge_True.

Unfortunately, using either of them as my group in the following formula
average({Sheet1_.Arguing},{@Discharge_True} still results in a value that only corresponds to @Intake_True.

Using running totals for the report I'm building would take significantly longer than if I could get this type of formula to work. It would be a difference of three running totals per item versus one formula per item (and it's a report of 100s of items).

I'll keep working with the groupings, but if you have any other advice I would VERY MUCH appreciate it.

Thank you again.