TM1 Forum

Hi Declan,

Thanks for the above to look like this
['IM ACC DATA Measures':'ACCURACY %']=N:If;(['ABS ERROR']=0,1,If((['ABS ERROR']>0)&(['Forecast']=0),0,1-(['ABS ERROR']\['FORECAST']));

But I get the message =N:if; missing semicolon

Thanks,

Joe

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

Hi,

I have been trying to use an IF function in a calculation section but I keep getting a syntax error saying ; missing left parenthesis.

Can anybody help me solve this?
Thanks