Forum Discussion
admin11
Memorable Member
Memorable MemberHow to modify the YTD GP% expression , so that it will return GP < 20% ?
Hi All I have below expression working fine :- GP% YTD = DIVIDE(([Sales YTD] - [COST YTD]),[Sales YTD]) May i know how to modify the expression , So that it will return only those 3 row whe...
admin11 , Try a measure like
GP% YTD =
var _1 = DIVIDE(([Sales YTD] - [COST YTD]),[Sales YTD])
return
if(_1 <.2 , _1, blank())
amitchandak
Super User
Super Useradmin11 , Try a measure like
GP% YTD =
var _1 = DIVIDE(([Sales YTD] - [COST YTD]),[Sales YTD])
return
if(_1 <.2 , _1, blank())
admin11Memorable Member
Memorable MemberThank you very much , it work fine.