-
Re: Sequencing columns in a Anaplan Export File.
@RohithN - You correctly mentioned the sequence as first page dimensions, rows, and then columns. But columns come at the end only. I don't think it is configurable.1 -
Re: Top-Up current period value to specific period
Here is the solution Offset Period: IF ISNOTBLANK(Date Period TO) THEN MONTH(Date Period TO) - MONTH(Date Period FROM) ELSE 0 Final: IF Offset Period <> 0 THEN Forecasted Value ELSE POST(Foreca…1 -
Re: Calculate the total interest from the first blank to the last blank in the 'Interest Expense' column
@AtzdGr8 I tried to break down the solution, but it's not fully complete yet. Let me share my approach so far. I set up the same structure as yours and used the MOVINGSUM function for the intere…1 -
Re: Returning same value from same Line Item but different items
To avoid circular reference, you need to stage the calculations to a different line item. In this case, you can create another line item (Sales Staging) and calculate / fetch the values for Scenario …1 -
Re: Definitive Current User in a formula
In the same module where you have the Approver line item with users list, create 2 line items DCA Read = NOT DCA Write DCA Write should have all the lists applied in the module plus users list. And f…1

