How to insert condition to none SET expression ?

[paulyeo11]

Hi All

I have below expression :-

sum(DISTINCT  NET_PROFIT_A_TAX_C)

/

sum(DISTINCT  REVENUE_C)

May i know how to insert the below condition to  above expression :-

COMPETITOR = {'WAGO', 'iTDS')

Paul

[paulyeo11]

my QV Doc

[sunny_talwar · Accepted solution]

May be like this:

Sum(DISTINCT {<COMPETITOR = {'WAGO', 'iTDS'}>} NET_PROFIT_A_TAX_C)

/

Sum(DISTINCT {<COMPETITOR = {'WAGO', 'iTDS'}>} REVENUE_C)