Set analysis issue

[nareshthavidishetty]

Hi ,

We have used the set analysis and it gives right results.

But the syntax is showing error script as below.

Is there any way to get the same logic in different syntax.

Logic:

sum({$<[Calendar Date]={'>=$(=Date(Monthstart(max([Calendar Date])), 'DD-MMM-YYYY')) <=$(=Date(MonthEnd(max([Calendar Date])), 'DD-MMM-YYYY'))'}>}[# QN Initiated])

Thanks..

[tresesco · Accepted solution]

Try like:

sum({$<[Calendar Date]={">=$(=Date(Monthstart(max([Calendar Date])), 'DD-MMM-YYYY')) <=$(=Date(MonthEnd(max([Calendar Date])), 'DD-MMM-YYYY'))"}>}[# QN Initiated])

Note: Replaced single quotes with double quotes (in red)

[nareshthavidishetty]

Hi,

What is the difference between these ',".

I'm getting same results as well.

Thanks..

[tresesco]

single quotes should be used for exact match, whereas double quotes for searching. In your expression, with double quotes, the error highlighting should go off. And since you have already said that you are getting the right result, that means same is correct one.

[marcus_sommer]

The best explaining is here: Quotes in Set Analysis.

- Marcus