Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone:
This is my code to get Week information.
=Sum( {$<YEAR = {$(#=Max(YEAR))}, [Week No]= {$(#=Max([Week No]))}, CT -= {ITC}, DCCF = {YES}>} AMOUNT)
I need to modify this code to say today()-1
thanks,
J
Do you have a date field in your app? What is it called? What is its format?
Yes I have a dimension called "Date" its mm/dd/yyyy
Then this
=Sum({$<Date = {"$(=Date(Today()-1, 'MM/DD/YYYY'))"}, CT -= {ITC}, DCCF = {YES}>} AMOUNT)