Hello,
I want to count the number of weekends between two dates.
Do you have a solution for this demand ?
Thanks a lot
@TAGORTI ,
See if this works for you...
Create a SYS Time module by Day with the following line items:
Date: start()
Day Nbr of Week: WEEKDAY(Date)
Count Saturdays: IF Day Nbr of Week <> 6 THEN 0 ELSE 1
In another module that is not dimensionalized by Time, you have 3 line items:
Date1: date formatted that is entered
Date2:date formatted that is entered
Number of Weekends:TIMESUM('SYS Time Filter - Day'.Count Saturdays, 'Date 2', 'Date 1')
Hope this works for you,
Rob
Hi,
Try this:
ROUND(('Date 2' - 'Date 1') / 7)
Regards,
Anirudh
@rob_marshall
Thanks a lot.
It worked for me, I did some modifications. It fits my need.
Anaplan Modelers: Has Anyone Recreated a Showcase Model for Learning Purposes? One of the most valuable learning resources I've come across is Anaplan's Modeling Showcase. It features sophisticated, real-world model examples that offer an incredible opportunity to learn how experienced model builders structure their…
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
