Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hy guys ,
Please help.
I have values for each month :
Jan-1
Feb-3
Mar-2
Apr-4
May-7
Jun-6
Jul-9
Aug-12
Sep-33
Oct-1
Nov-4
Dec-2
I need to take the maximum value from those month : 33 in this case . I need this to be done in an expression. Could you please help.
Thanks,
Razvan
Try this:
SUBFIELD(month ,'-',2) as num
then can take max(num)
max(SUBFIELD(num,'-',2))
The data is not as a string. It is in a table , in different columns. One column for month , and another for values.
An I need to calculate the max without selecting any month...
Can u make a variable
vmax =max(value)
and expression like
if(value=vmax,value) and month as dimension.