Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
need help.
I need to track half yearly records - for instances any new records.
I have field Year = 2015, number(version)= 2,3 type = 1ST Half or 2ND Half
i can max(year) or max(number) , but how to max(type) , because it is in string?
EXPECTED RESULT: I want to know what is the new record for year 2015, 2nd half compare to 1st half.
i have such front end code: but now. user wants to see Half Yearly, rather than compare year by year.
(Count(DISTINCT {1<number = {'$(=max({1}number))'}, year = {'$(=max({1}year))'},
item_id = e({1<item_id = {"=Count({1<year = {'<$(=Max({1}year))'}>} item_id) > 0"}>})
>} item_id))
should i write in such : ?
(Count(DISTINCT {1<number = {'$(=max({1}number))'}, year = {'$(=max({1}year))'}, type = {'$(=maxstring({1}type))'}
item_id = e({1<item_id = {"=Count({1<year = {'<$(=Max({1}year))'}, type = {'<$(=Maxstring({1}type))'}>} item_id) > 0"}>})
>} item_id))
Rgds,
Jim