I was trying this forumla for Beginning inventory Line item, it says below error.
My DAT01 Beginning inventory also good for my concern. Is there anything missing from my side.
@sarathkumar2303 - The error states that it cannot find that line item. Do you have a line item called Not first week in SYS module? Alternatively, you can add the NOT in the formula as IF NOT SYS…firstweek then…. else…
@devrathahuja, i don't have Not 1st week line item. However now i added still same issue. Could you please help me?
@sarathkumar2303 - The name of the line item needs to be the same in the formula. In your formula instead of typing that line item name, click on the line item in the SYS module and it will pick the correct line.
We have a question regarding the behavior of the XL3dowriteback formula. Our understanding is that this formula allows writeback to be controlled on a cell-by-cell basis. In our operation, when we need to clear a previously written-back value due to an input error or similar reason, we do so by entering 0. However, when…
We added new bed types to eventually move from the old "All Beds, single, double" I inputted the data into the new bed types Went to double check flow into other modules and found that they are being double counted even though I blanked the original columns out. I am not sure why it is still counting All Beds even if it is…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
