Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All, I have a text field OPENWEEK with the following values ('2013-1'.....upto '2013-45')
I am using a variable RaisedWK =maxstring(OPENWEEK) which returns '2013-9' as the maxvalue
How to tweak the maxstring function to get 2013-45 has the max value?
This is the expression which i am using in the straight table Count(if(OPENWEEK=RaisedWK,Number))
Hi Basanth,
Do you have date field? If that, then we can try
RaisedWK=Only({$<[DateField]={$(=Max([DateField]))}>} [OPENDWEEK])
Regards,
Sokkorn