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?
@dan_ossmann
You mean something like this?
Anapedia Link: https://help.anaplan.com/a445eb44-98b7-4abc-8748-92435187e423-WEEKDAY
Do you mean this? WEEKDAY(ITEM(TIME)) and is number fomatted.
yes. exactly like that. I knew it had to be simple. :)
Perfect, if you would please, mark that as an answer so it can help others who might have the same question.
Thanks
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a listβ¦
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New β New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, noβ¦
Why in my model output is blank, after send explainability data.
