Hi There,
I need to create an adjusted weeks on floor metric. I currently have:
(vMaxDate - Min(FIRST_ACTIVITY_DATE) / 7) which works fine.
However, the users want to exclude weeks where Product Units On Hand (in stock) <= 0 (OH_Units).
Tried a few variations on below to no avail...
(vMaxDate - Min(FIRST_ACTIVITY_DATE) / 7)
-
if(OH_Units) <= 0, count([WEEK_ENDING_DATE]),0)
Please help if you can!!