How it's possible to achieve date difference in PCMCS
how it's possible to achieve date difference in PCMCS?
I have project dimension and every project has a start date and an end date. My goal is to count how many days the project has been active in each month.
For example: start date 01042023 end date 01052023, so we have 30 days for April and 1 day for May (it will be great to exclude Saturday and Sunday).
Is it possible to calculate this in PCMCS? How i have to handle start and end date (attribute dimension or other way)?
Thank you in advance
Content (please ensure you mask any confidential information):