-
Re: Formula
Hello @NAIDU There are several ways you could do it. Using formulas, using process etc. But keep PLANS and DISCO in mind. The solution must be sustainable. I strongly advice not to use Hard coded for…2 -
Re: Value referenc Price effective date
Hello @Wendy , This is one way to acheive this, but there could be more as ways as well. Average PriceTransactions.FOB[AVERAGE: Transactions.Effective Date, AVERAGE: Transactions.Product Code]Last tr…2 -
Re: Get value of Day(numerical) from Timescale Day
No, the DAY function can only accept date as input argument. So it does not accept the time list members. It could be something like this..DAY(START(ITEM(Time))), I prefer DAY(START()) Thanks Arun2 -
Re: Get value of Day(numerical) from Timescale Day
Please use the DAY() function. https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/DAY.html Create a line item - number formatted and use the formula DAY(START()) in your moudule with…2 -
Re: Behaviour of SEQUENTIAL parameter in RANK function
I understand your requirement now. SEQUENTIAL is not giving us the display sequence, it is the order of creation of the list item itself i believe. I think you can achieve this by a workaround proces…1

