Average of Daily Data

I am building a new model and have daily data. Our data is only for weekdays though. So when I use the average Sum method Anaplan averages in a zero for Saturday and Sunday which is obviously not what is required. Seems like there should be an option in Model Settings/Time to allow me to define what a week is but there is not. Any ideas on how to work around this issue?

Accepted answers

All comments

PrevContributor

A related issue is that I can't define the start or end day of my weeks. In this case Anaplan's definition of starting on Sunday matches mine but other companies I have worked for that would not have been the case. Retailers often start on Saturday or Monday.

michael.moore

You can get close to a solution with the WEEKDAY() function and a few extra line items. Create a Weekday Count line item that will have a 1 value on weekdays and 0 value on non-weekdays using the formula: IF WEEKDAY(END()) < 6 THEN 1 ELSE 0. Sum that and your original Daily Data line item and create a new line item to divide your data by Weekday Count.

The WEEKDAY() function takes an optional parameter to indicate the start of the week. This may help to address calendars that start the week on a different day.

Quick Links

Can you help?

Unanswered questions

Cloud works on UX page
I am unable to see the cloudworks integration on the UX page. Can you advise what I am doing wrong
how to count how many times an action has run?
I want to create a line item which will increment by 1 every time an action is run manually. This action is an import which doesn't involve any file upload to anaplan. The module where I want this line item has users list & SKU list dimension. No time. So basically, I want to track how many users have selected an SKU and…
Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…