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)
Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.