I need to create a caluclated field that returns to me the sales relative to a certain date. This needs to be a calculated field because i'm dealing with several other metrics that will not be constrained to this particular date field.
Two particular metrics I need are:
Can someone help me figure out this calculation? I'm getting an error that tells me I can't compare datetiem and float values.
if [date]<#11/7/2011# then "Before" elseif [date]>#11/7/2011# then "after" end