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.
Even if i remove that it doesnt work as required.
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
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.
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.
Formatting was the issue. Sorry for the whole trouble
Def. suggest you to read this... you will love it
Sure Thanks