MIN expression to exclude 0 value

[JulieMcD240]

I am trying to get the min value of age for a group that excludes 0 (0 represents unknown age). I have the following expression that is not working.  Any help would be greatly appreciated.

MIN({<[STATUS1]={'A'},[STATUS2]={'B'}, AGE={'<>0'}>} AGE)

DataSet:

STATUS1	STATUS2	AGE
A	B	25
A	B	18
A	B	0
A	B	0
B	A	22
B	A	0

[BrunPierre]

Have you already tried to uncheck 'include zero values' under the dimension or under Add-Ons-> Data handling?

[JulieMcD240]

Yes, but no luck.  I checked Supress Zero Values under Data Handling but the MIN still comes out 0.  Thank you.

[Kushal_Chawda · Accepted solution]

@JulieMcD240  you are using <>0 which is search condition in set analysis . You need double quotes to apply this filter

MIN({<[STATUS1]={'A'},[STATUS2]={'B'}, AGE={"<>0"}>} AGE)

[BrunPierre · Accepted solution]

Like this  perhaps.

MIN({<[STATUS1]={'A'},[STATUS2]={'B'}, AGE-={0}>} AGE)

[Prem0212]

This expression will work for you.

Min({<Age=-{0}>}Age)

Please like and accept the solution if u find an answer

[JulieMcD240 · Accepted solution]

Thank you.  Yes, this worked!

[Kushal_Chawda]

@JulieMcD240  Mark appropriate answers as correct solution