Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I cant seem to find the syntax error in the formula below but i would also like to add "If this is not populated I want the date to chose the current date".
how can I add this to the following syntax please.
So if the 'AsAtDate' is populated the date is taken from this but if left empty the data is taken from today.
SUM( {$<%Date<={AsAtDate}, RecordType= {'WebTraffic'}, Area= {'SR'} >} Sessions )
Thanks Laura!! I am assuming you are congratulating me for 100k points
yes. I think your great!