Count Distinct Over If

Question & Answer
, , , , ,
1

Hi Everyone,

I have a need to do a count distinct over if. Unfortunately there’s no function for this, QS issues an error when I try to combine functions. The formula looks like this, but I need to replace avgOver with distinct count. Anyone have any ideas?

avgOver(

ifelse(${CurPlan}={Name (Plan)} AND ${CompElement2}=‘Base’,{Base MRP (CompositeValue)},NULL),[{Name (Plan)},{Name (Paymarket)},{Job Code (CompanyJob)}],PRE_AGG)

Thanks,
Keith

2

Hi @keith.fortier

You can do distinct count over. This is your go to resource for this question.

Regards,
Giri