|
发表于 2014-3-17 12:28:40
|
显示全部楼层
Jwreford wrote:Hi,
Sorry it would not let me post earlier, here is the code,
if(['ABS ERROR']=0,1,if(&(['ABS ERROR']>0,['FORECAST']=0,(1-['ABS ERROR']/['FORECAST']))
Thanks,
Joe
Try:
Code: ['Destination']=N: If ( ['ABS ERROR'] =0, 1, If ( ( ['ABS ERROR'] > 0 ) & ( ['Forecast'] =0 ), 1- ( ['ABS ERROR'] ['FORECAST'] ), 0 ) );
You need to fill the 'Destination' part with whatever the destination measure is and the final 0 is just a guess on what you will want the result of the ELSE to be. |
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有帐号?立即注册
x
|