Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I was wondering if someone could kindly cast an eye over my set analsyis statement as it currently returning Null values
My aim is to produce a sum of data for the current day. My dataset contains data for the entire quarter
My Test field returns data in this format: DD/MM/YYYY (14/01/2013)
My Today() functions returns values in this format DD/MM/YYYY (14/01/2013)
=SUM( {1<Test={$(=Date(Today(), 'DD/MM/YYYY'))}>}QuarterlyBreaches_Breaches)
Kind Regards
Helen
Helen
try putting quotes around the date expression:
=SUM( {1<Test={"$(=Date(Today(), 'DD/MM/YYYY'))"}>}QuarterlyBreaches_Breaches)
HTH
Jonathan
Helen
try putting quotes around the date expression:
=SUM( {1<Test={"$(=Date(Today(), 'DD/MM/YYYY'))"}>}QuarterlyBreaches_Breaches)
HTH
Jonathan
Hello Jonathan
Thank you for your reply. You beat me to it, I had just found out about the "" quotes online and it now works perfectly
I was just about to re-post, so thank you for your reply
I am back on track again now
Thanks
Helen