Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to have something like this:
count({<DATE1={"=aggr(max({<DATE1={"=Date(Max({<DATA_TYPE={"DataType1"}>} DATE1))"}>} DATE1),YEAR)"}>}DATE1)
I need this to get the maximum date of a certain data type for a given year.
My problem is I have "" inside another set of "" and it messes the expression.
Is there any escape character to do this?
Best regards.
Can you use variables as workaround ?
I am little confused by your second search expression, shouldn't something like
=count({<DATA_TYPE={DataType1}, DATE1={"=aggr(max({<DATA_TYPE={DataType1}>} DATE1) ,YEAR)"}>} DATE1)
not be enough?
No...
I don't know if the No is for me or swuehl.
Try this:
create a variable vDataType1Date:
=Date(Max({<DATA_TYPE={"DataType1"}>} DATE1))
Then a variable vYearDateMax:
=aggr(max({<DATE1={"$(vDataType1Date)"}>} DATE1),YEAR)
and here is your expression:
=count({<DATE1={"$(vYearDateMax)"}>}DATE1)
Just do it by step to take care of date format.