Leave 0 values out of c calculation

[klaus_feldam]

A really simple question about using the FirstSortedValue calculation... I am almost embarrassed to ask such a simple question, but I have never used this function before.

Basically, I only want to consider values in the BMI column greater than 0.

See attached table.

[jwjackso · Accepted solution]

Try something like FirstSortedValue({<BMI={">0"}>}BMI,[Date])

[Kushal_Chawda]

@klaus_feldam  how about this if you uncheck below option?

[klaus_feldam]

Tada! Thank you very much.