Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have an expression like:
SUM({<DATE(FLOOR(SalesDate))={">=addyears(today(),-1)<today()"}>}Sales), but it's not returning back results. I guess it doesn't allow me to do something like: DATE(FLOOR(SalesDate)). I'm wondering how should I rewrite this function?
Let take this step by step
Your set syntax is wrong change to
SalesDate={">=$(=addyears(today(),-1))<$(=today())"}
on the floor part
i actually havent tried DATE(FLOOR(SalesDate)) in the set expression before. i would recommend doing this step in the script.
Is your salesdate a timestamp? if not you dont need the floor function
Let take this step by step
Your set syntax is wrong change to
SalesDate={">=$(=addyears(today(),-1))<$(=today())"}
on the floor part
i actually havent tried DATE(FLOOR(SalesDate)) in the set expression before. i would recommend doing this step in the script.
Is your salesdate a timestamp? if not you dont need the floor function