Use Time dimension in a formula

dan_ossmann

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?

rob_marshall

@dan_ossmann

You mean something like this?

Anapedia Link: https://help.anaplan.com/a445eb44-98b7-4abc-8748-92435187e423-WEEKDAY

andrewtye

Do you mean this? WEEKDAY(ITEM(TIME)) and is number fomatted.

dan_ossmann

yes. exactly like that. I knew it had to be simple. :)

rob_marshall

@dan_ossmann

Perfect, if you would please, mark that as an answer so it can help others who might have the same question.

Thanks