-
Re: Changing fiscal year start month without losing data
Another possibility: Your data will only be deleted if the time periods are totally incompatible with the new settings. If you update the Current Fiscal Year at the same time as Fiscal Year Start Mon…2 -
Re: How to refer a properties in formulas
You need to sayB = List.Property[LOOKUP: A] where List is the name of your list and Property is the name of the property you want to get.3 -
Re: Ratio to all & Ratio to parent within a list
Ratio to All is easy: the formula isSales / Sales[SELECT: Product.All Products] (I'm assuming your list is called Product and the measure you're working with is called Sales.) However, for …4 -
Re: Anaplan equivalent of the "Product" Function
You can do this, but you need to do it in a couple of stages. Let's say you've got a line item called Factor and you want the summary to be PRODUCT. You need to create an intermediate line …5 -
Re: ITEM(Versions) : Versions is not recognized as a hierarchy in the model
That's right - the ITEM() and FINDITEM() functions don't work on the Versions list. You have a few other functions that you might be able to use instead: ISCURRENTVERSION() and ISACTUALVERS…8

