Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends
I am trying to add field “other” and remove the subtraction calculation from below expressions. Before I had 3 columns, now one more column has been created so I do not have to use subtraction to get "other". Help please. I have tried few ways but column fields are coming up with - .
if([F Group]='UK', sum({<Year={"$(ThisYearByOrderDate)"}>} [UK Forecast]),
if([F Group]='USA', sum({<Year={"$(ThisYearByOrderDate)"}>} [USA Forecast]),
if([F Group]='EU’, sum({<Year={"$(ThisYearByOrderDate)"}>} [EU Forecast]),
if([F Group]='Other', sum({<Year={"$(ThisYearByOrderDate)"}>} [Forecast] - (if(isnull([UK Forecast]), 0, [UK Forecast]))
- (if(isnull([USA Forecast]), 0, [USA Forecast]))-(if(isnull([EU Forecast]), 0, [EU Forecast])))
,sum({<Year={"$(ThisYearByOrderDate)"}>} [Forecast])))))
I am using below but it’s is not working:
if([F Group]='UK', sum({<Year={"$(ThisYearByOrderDate)"}>} [UK Forecast]),
if([F Group]='USA', sum({<Year={"$(ThisYearByOrderDate)"}>} [USA Forecast]),
if([F Group]='EU’, sum({<Year={"$(ThisYearByOrderDate)"}>} [EU Forecast]),
if([F Group]='Other’, sum({<Year={"$(ThisYearByOrderDate)"}>} [Other Forecast]), [Forecast]))))
Got it, done now by following expression.
if([F Group]='UK', sum({<Year={"$(ThisYearByOrderDate)"}>} [UK Forecast]),
if([F Group]='USA', sum({<Year={"$(ThisYearByOrderDate)"}>} [USA Forecast]),
if([F Group]='EU’, sum({<Year={"$(ThisYearByOrderDate)"}>} [EU Forecast]),
if([F Group]='Other’, sum({<Year={"$(ThisYearByOrderDate)"}>} [Other Forecast]), sum({<Year={"$(ThisYearByOrderDate)"}>}[Forecast])))))
Got it, done now by following expression.
if([F Group]='UK', sum({<Year={"$(ThisYearByOrderDate)"}>} [UK Forecast]),
if([F Group]='USA', sum({<Year={"$(ThisYearByOrderDate)"}>} [USA Forecast]),
if([F Group]='EU’, sum({<Year={"$(ThisYearByOrderDate)"}>} [EU Forecast]),
if([F Group]='Other’, sum({<Year={"$(ThisYearByOrderDate)"}>} [Other Forecast]), sum({<Year={"$(ThisYearByOrderDate)"}>}[Forecast])))))