I need to build a Slope and intercept formula where my X values are dates.

Options

I need to build a Slope and intercept formula where my X values are dates. Like in the screenshot. Since in Anaplan (the normal build) way we calculate by using the formula as mentioned. How to convert dates into number format or otherwise how can we achieve the same

Example :

Answers

  • To handle dates in Anaplan for calculating slope and intercept, convert the dates into numeric values that represent the passage of time
    Set up a line item (let’s call it Base Date) with the date format and manually set it to the earliest date in your system (Like January 1, 1900 )
    Convert a date to a number for your purpose, you can use the DATE function with the VALUE function.