Use Time dimension in a formula
I have a module with Day as the time dimension. I would like to refer to the module time dimension in a formula. For example, WEEKDAY(time dimension). So that on January 1, 2023, the line item would return 7 (for Sunday). Is this a thing?
You mean something like this?
Anapedia Link: https://help.anaplan.com/a445eb44-98b7-4abc-8748-92435187e423-WEEKDAY0
Do you mean this? WEEKDAY(ITEM(TIME)) and is number fomatted.0
yes. exactly like that. I knew it had to be simple. :)0
Perfect, if you would please, mark that as an answer so it can help others who might have the same question.