Forum Discussion
harikm007
09-27-2024Data Warehouse
Hi liamcameron ,
One option is to use a CASE statement instead of '[# of completionId]'. So the formula will be:
avg([PersonId], case when[# of completionId] > 50 then[# of completionId] else null end)
-Hari