-
Referencing a property of a parent list in a list item
Need to reference the property of a Parent list in a list item of a module Example Module: Deals List Item: SKU Tax Lists: SKU (Child), Product (Parent) Desired outcome: function: Deals.SKU Tax = Par…1 -
YEAR() function not working
My Fin Year item is set to Time Period format: "Year". Our financial year setting is April to March. Attached is the Anaplan example and my working model that seems to return different resu…1 -
How to Calculate Months Difference between Two Dates
Does anyone know how to calculate the number of months between two dates? Calculating the days is easy per my formula in the image below.1 -
Referencing Switchover Period
Is there any way in a formula to reference the Switchover period for a version? The module is pulling in data from a list across the time periods but if the cell is for a time period prior to the Swi…1 -
Formula for entering value
Is there a way to use a formula to calculate the value your are inputting into the cell? For example, if I'm loading a forecast and am inputting the forecast value for a specific month, I'm…1

