Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Another way to do the same:
=Max([ENERGY YELDED])-Min( {<[ENERGY YELDED]= {"=Min([ENERGY YELDED])>0"}>} [ENERGY YELDED])
=
if(min([ENERGY YELDED ])=0,max([ENERGY YELDED ])-min([ENERGY YELDED ],2),max([ENERGY YELDED ])-min([ENERGY YELDED ]))
Another way to do the same:
=Max([ENERGY YELDED])-Min( {<[ENERGY YELDED]= {"=Min([ENERGY YELDED])>0"}>} [ENERGY YELDED])
Thanks Icz,
works great !
i tried this expression but doesn't work....
Thanks anyway