;Create a formula without changing past data
Hello,
in the past, I had to manually insert data into an input module. Meanwhile, our anaplan models have been further developed and from now on I could automatise the line items of this input module with a formula by looking up this data in another model. But if I start adding a formula for this line item, I am going to overwrite all the data from the past. I don't want to do that. Are there any specific solutions for this? something with dates maybe (before this date and after the date? Some usefull help would be kind!
Answers
-
i think i can do a workaround with a second module, but all help is welcome!
0 -
@filipsneyers You can create another line item and refer the initial input data and you can write your formula like if Input data <>0 then refer the input data line item or else write the formula.
1 -
Let's say in your existing module, you've got a user inpur line item (here, for example: it's Salary)
Create another line item (IMP Salary) and export the original salary and import it into the new IMP Salary line item.
Once it's imported, you can write the formula in the Salary Line Item:
IF IMP Salary <> 0 THEN IMP Salary ELSE Salary new logic
1 -
indeed, another line item is enough. Module not necessary. Thanks alot!!!
0
