Averaging in Report footer If condition is met

[GoBlue]

I have a list of values in a report I want to average at the end, but I only want to include the records value in the average if a condition (named [split]) is no. Can that be done? I have the formula =(IIF[split]=false, Avg([x]/[y]). But that seems to be doing the same as =Avg([x]/[y])

[NTC]

assuming 'split is no' means it is Not Checked; try

=(IIF([split]<>-1,0, Avg([x]/[y]))

not 100% sure on this though......

[GoBlue]

assuming 'split is no' means it is Not Checked; try

=(IIF([split]<>-1,0, Avg([x]/[y]))

not 100% sure on this though......

I tried it, but it did not work. It evaluated the data as 0. Any other thoughts?

[NTC]

am not real certain on Avg([x]/[y])

your initial post implies that it works...and you only needed to apply it to sub set of records....are you sure about that method?