Announcements
cancel
Showing results for
Did you mean:
Creator III

Set analysis issue

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

1 Solution

Accepted Solutions
MVP

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)

4 Replies
MVP

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)

Creator III
Author

Hi,

What is the difference between these ',".

I'm getting same results as well.

Thanks..

MVP

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.

The best explaining is here: Quotes in Set Analysis.

- Marcus

Community Browser