Formula help

[Tragertt]

I have a formula that works very well but I need to not include any number that is 0.00. Here is the code

average(
select(main[TGPA], ([School name] = [_thisrow].[school]))
)

Where would I add the part of code that excludes 0.00 and what would that code be?

[Ceke]

Try this way:

average(
select(main[TGPA], and([School name] = [_thisrow].[school],[TheColumnThatContainsTheNumberIGuessTGPA]<>0.00))
)

[Tragertt]

That code worked but for some reason it made the GPA go down when it should of gone up

[Ceke]

Do you have alsa a negative GPA?

[Tragertt]

no, it goes from 0.00 to 5.00

[Ceke]

Try to make it greater..

average(select(main[TGPA], and([School name] = [_thisrow].[school],[GPA]>0.00))

)

[Ceke]

You can also try a simulation in a Google spreadsheet, to see what's the true result