-
Re: Weekvalue formula
Hi Hina I think you should mark Kavins post as solution 😉2 -
Re: Circular reference: SELECT function
Hi Mickel Since you are trying to refer the same line item in the formula for which the formula is being written, even though you are using the select, try to plan them in different line items and th…3 -
Re: Circular reference with previous value
Hi Only way you can achieve this would be using offset and other time based functions. The limitation is it just works with the time list but does not work with general lists.3 -
Re: Read Only for submit once approved
Use two line items Submit and Approve Third line item should be opposite of approve (Reverse Approve) Reverse Approve formula to be "NOT Approve" Both Boolean formatted Use the dynamic cell…3 -
Re: NPV Formula with time adjust.
Hi Have just used simple case for CF and Rate and NPV to show the results of excel and anaplan. Attaching the screenshot along with formula in Anaplan.3

