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.

[nithin_miryala]

Even if i remove that it doesnt work as required.

[sunny_talwar]

Can you actually post the screenshot of the chart (instead of expression editor) to show what it shows in the label section of the expression?

Essentially, I want to see this

Expression in the expression label (make sure you have removed any label names from the expression label on the expressions tab

[nithin_miryala]

Here is the screen shot. of what the expression label says.

When i go and select the 12/18/2017 in the BaseDTS the values look like this and This is the desired output.

[sunny_talwar · Accepted solution]

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.

[nithin_miryala]

Formatting was the issue. Sorry for the whole trouble

[sunny_talwar]

Def. suggest you to read this... you will love it

Dates in Set Analysis

[nithin_miryala]

Sure Thanks