How to modify the YTD GP% expression , so that it will return GP

Question

Hi All&nbsp;I have below expression working fine :-GP% YTD = DIVIDE(([Sales YTD] - [COST YTD]),[Sales YTD])&nbsp;May i know how to modify the expression , So that it will return only those 3 row where&nbsp;GP less then 20%&nbsp;Paul&nbsp;

amitchandak · Accepted Answer

admin11 , Try a measure like 
&nbsp;
GP% YTD = var _1 = DIVIDE(([Sales YTD] - [COST YTD]),[Sales YTD])return if(_1 &lt;.2 , _1, blank())

Forum Discussion

How to modify the YTD GP% expression , so that it will return GP < 20% ?

2 Replies

Related content

Help!!! Expression Error

Regular expression

LASTNONBLANK when expression only returns blank

Calendar Table returning error: The expression specified in the query is not a valid expression

Expression Error