I am trying to create a dashboard or just an olap table in which I can see the open items that will be becoming due in the next few weeks (1 to 3 weeks). My question is how to create a formula that gives me that based on today’s date (not on a fix date), as my expectation is that tomorrow a new set of invoices is displayed based on tomorrow’s date.
Data Model B2C
net due date already in the data model
BSEGMERGED table
Hello Andrada,
By using function TODAY() (https://help.celonis.cloud/help/display/CIBC/TODAY) you can easily accomplish this. You can calculate DAYS_BETWEEN (https://help.celonis.cloud/help/display/CIBC/DAYS_BETWEEN) your net due date and TODAY() and check if it is below your desired target to show on that olap table or dashbord.
Hope this serves you to solve this.
Best regards,
Pablo Maceda
Hello Pablo,
Thank you very much for your answer. It really helped :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
