Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I need help converting the below IF statement to Set analysis;
COUNT(
DISTINCT IF(
Folder_Open_Date >=vstart_date AND
Folder_Open_Date <=vend_date AND
[Status]<>"V" AND [Status]<>"Void"
,[Claim]
,NULL
)
Thanks in Advance.
In addition to what @Digvijay_Singh asks you,
Could you share us the definition in script of the field [Folder_Open_Date] or a screenshot of what it looks like used in a chart?
it's says ok at the bottom of the Edit expression.
that is the above date that show up
SET DateFormat= 'YYYY-MM-DD'; this my date format