peter_mcanena 
-
Re: ROUND Function Not Always Rounding
Hi all, This looks like a bug in Anaplan (and it's still happening as of today). However, you can get round it by using a different syntax for the ROUND() function. Instead of rounding to 2 deci…8 -
Re: ITEM(Versions) : Versions is not recognized as a hierarchy in the model
It works fine for me - I've just tested it. Also I can see from your screenshot that Anaplan has accepted your formula Actual YTD - 'FC2' so everything looks fine in your model too. Ma…1 -
Custom Sum without Introducing New Dimensions
When you perform a custom sum (either because you've switched off the line item's sums or because you're calculating a partial sum or using a different summary method), the usual metho…5 -
Goal Seek
Given a complex function y = f(x), you sometimes need an inverse function that finds the value of x required to produce a given value of y. In Excel this can be done using the Goal Seek feature, but …6 -
PREVIOUSITEM() - PREVIOUS() on a list
Referring to the previous item in a list is a nightmare: You can write a lookup to find the previous item, but as soon as you try to use it you get a circular reference. Sometimes you can get round t…26
