Expression formating error.

[nithin_miryala]

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.

[sunny_talwar]

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

[sunny_talwar]

Also check this

Dates in Set Analysis

[nithin_miryala]

Even if i write like that.

That output value is 1987 not the desired output

[luismadriz]

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

[mgavidia]

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...

[sunny_talwar]

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

[nithin_miryala]

Please look at the screenshot

the whole BaseDts is being ignored.  this expression is in Straight table

[sunny_talwar]

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(...))"}

[nithin_miryala]

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