Hi everyone. may i know how can i start in a specific month row based on my specific month or date.
Here is my criteria:
and this is what i want to display in m y module:
Thank you.
Hi @ArthurAng - you will likely need to use a logical IF THEN ELSE function as part of your calculations. I'd also recommend adding a Boolean line item to define the periods where load is active, this is where you define you criteria.
Time and date functions can be used to compare your date criteria to the period in question. As an example "END() >= First Payment" would indicate if the payment commence prior to the end of that period, returning FALSE for Jan/Feb 24 and TRUE for all future periods. Links below to some helpful time/date functions.
https://help.anaplan.com/end-3d41a077-b391-45ca-a6e2-0c6dfaaeb85f
https://help.anaplan.com/start-bc44fa0b-7af8-4a8f-ad8f-cbeaccf22003
https://help.anaplan.com/inperiod-3b64fe69-0d31-49b8-ab40-e7c1a3d01137
First, you have to create a Time filter
Next, create a calculation module for interest & principal using Time Filter
Thank you everyone
Now I faced below warning But I cannot find any delete action for those users I don't need anymore Can I have any action to solve this warning?
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!
