Minimum value different from 0

[Anonymous]

This expression is OK but doesn't work properly.

if([ENERGY YELDED]>0,(max([ENERGY YELDED]))-min([ENERGY YELDED]))

I want that the expression does not consider the value 0 and the a minimum value different from 0

For examplie :

ENERGY YELDED value : 

4

7

12

0

5

9

MAX = 12   MIN = 4   =  MAX - MIN = 8

Anybody can help me?

Thanks

[lironbaram]

=

if(min([ENERGY YELDED ])=0,max([ENERGY YELDED ])-min([ENERGY YELDED ],2),max([ENERGY YELDED ])-min([ENERGY YELDED ]))

[Luis_Cortizo · Accepted solution]

Another way to do the same:

=Max([ENERGY YELDED])-Min( {<[ENERGY YELDED]= {"=Min([ENERGY YELDED])>0"}>} [ENERGY YELDED])

[Anonymous]

Thanks Icz,

works great !

[Anonymous]

i tried this expression but doesn't work....

Thanks anyway