How to start in a row based on specific date

Question

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.

Tiffany.Rice · Accepted Answer

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

CommunityMember111277 · Accepted Answer

First, you have to create a Time filter

Next, create a calculation module for interest & principal using Time Filter