Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this:
Sum(DISTINCT {<COMPETITOR = {'WAGO', 'iTDS'}>} NET_PROFIT_A_TAX_C)
/
Sum(DISTINCT {<COMPETITOR = {'WAGO', 'iTDS'}>} REVENUE_C)
my QV Doc
May be like this:
Sum(DISTINCT {<COMPETITOR = {'WAGO', 'iTDS'}>} NET_PROFIT_A_TAX_C)
/
Sum(DISTINCT {<COMPETITOR = {'WAGO', 'iTDS'}>} REVENUE_C)