Line Item that keeps subtracting based on what's left

jahurtado · 2023-08-18T01:34:21+00:00

There was an error rendering this rich post.

Hey, I would love to know if you can help me with this case. I'm trying to subtract the value of one Line Item from another depending on the result of the first one: For example, a projected stock value versus my financial target. It's easy in Excel, but I'm not sure how to perform this operation in Anaplan using a single Line Item that keeps subtracting based on what's left

Accepted answers

ramonito

Like this one,

All comments

ramonito

Hello Jahurtado, you use the function MOVINGSUM to do this

ramonito

Like this one,

jahurtado

Hello Ramonito, I want to express my heartfelt gratitude for your invaluable assistance! Everything worked perfectly. Merci beaucoup! 😎

Quick Links

Can you help?

Unanswered questions

別ディメンションで、セレクターをモジュールに返し、計算したい
下記のようなことがしたいですコンテキストセレクターの値を別モジュールに反映し、それを使って計算したいです。 selecter A-1 Dim code amount Select→ A-1 1 100 A-2 2 100 A-3 3 100 A-4 4 100 module Dim code amount key Flg A-1 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 2 2 50 A-2 FALSE 2 2 50 A-2 FALSE
Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…