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
I wanted to check if others are facing this specification difference between Grid Card in Additional Insight. When created using a Saved View, the Quick Sum bar feature does not work, but when created using the module directly, the Quick Sum bar works.
Does anyone have any documentation on the trade-offs of having 1 model for all components of planning (service revenue, product revenue, labour planning), vs multiple models 1 for each and a consolidation model to tie it all together?
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-yearβ¦
