Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Morning all,
Can someone help me with the following syntax please;
=sum({<[Date Received]={'$(=Date([Upload Date]))'}, [Sales Channel]={'FriendsLife'},[Conversion Status]={'2 Tender Doc Issued'}, Status={'Won','Live'}>}APE)
This works fine at the moment as the two date fields are normal date fields so DD/MM/YYYY, I need to change the two date fields to fields to MonthName fields so they now look like this MMM-YYYY e.g. Jan-2012
As soon as I change the field names in the above syntax the results stop working and I keep getting zero's...I can;t figure out for the life of me what the problem is.
The new fields are called Date Received Month/Year and Upload Month/Year
Can anyone help?
This has been answered in a separate post
This has been answered in a separate post