Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Struggling with the the above topic.
I have two variables which I am trying to pass into a Set Analysis calculation.
I'm getting Zero returned as my total based on the following syntax. Is this correct?
=sum({<ServReadings.DateRecorded= { "$(= '>=' & date(vStartDate,'DD/MM/YYYY') & ' <=' & date(vEndDate,'DD/MM/YYYY'))" }>} Readings )
Regards
Steve
Hi,
Try this expression
=sum({<ServReadings.DateRecorded= { ">=$(=date(vStartDate,'DD/MM/YYYY'))<=$(date(vEndDate,'DD/MM/YYYY'))" }>} Readings )
If not working then check whether the date formats are same in variable and DateRecorded.
Regards,
Jagan.