Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I have expression which i put inside of the set analysis of the other expression.
=$(=Max(Total BaseDate)) Result: 43087
=Date(Max( Total BaseDate)) Result: 2017-12-18 (Desired output)
=$(=Date(Max(Total BaseDate))) Result: 1987
I am unable to figure out what is wrong with last expression.
1) I see an equal sign before the date
Are you still using {"=$(=Date(....))"}... Please remove it
2) Is your BaseDTS format 12-18-2017 or 12/18/2017? I think you need to understand the importance of format in set analysis. if the format doesn't match, the set analysis don't really work... so make sure you have this correct.
I think the date is getting evaluated as subtraction 2017-12-18 = 1987.... but is this happening in set analysis? I think within set analysis it should work without any issues
{<BaseDate = {"$(=Date(Max(BaseDate)))"}>}
Note: No TOTAL needed within Max() function. Also, no = needed before Dollar sign expansion
Also check this
Even if i write like that.
That output value is 1987 not the desired output
Hi Sunny,
Great pick up that subtraction!!! It would've taken me ages to see it
Do you think that subtraction happened because of the = sign in front of the $ expansion?
=$(=Date(Max(Total BaseDate))) Result: 1987
=2017-12-18
You do not show your Set Analysis entry but it seems that what you are missing is the quotes.
Try this in your Set Analysis expression:
{"=Date(Max( Total BaseDate))"}
I don't think you need the TOTAL in your entry...
Would you be able to post a screenshot of your expression in a straight table without expression label and full expanded expression column, so that we can see what is the evaludated Date value within your expression
Please look at the screenshot
the whole BaseDts is being ignored. this expression is in Straight table
Did you miss the equal sign by mistake? And you added one before $? This is not what I mentioned, I mentioned the opposite of what you have done
{"$(=Date(...))"}
I was testing things and forgot to remove it..
please look at the updated one
Still the result remain same. expression ignores the condition for BaseDTS and just taking the min of ThirdNextAvailableDts