1 of 1 people found this helpful
Since you're using a data blend, there is a restriction
on using COUNTD() in calculations coming from a Secondary.
It is [Number of Days in Week] which uses COUNTD() aggregation
to calculate the number of days in incomplete Weeks (1 or 53).
You may use MAX() - MIN() +1 instead.
Please find the attached wb w/mods.
Hope it could help.
Much appreciated mate, all the “process rate” calculations are now functioning beautifully
You are a legend in my book!
Cheers and Thanx again,