IF statements in Cognoscenti Insight

a23742212

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

aki秋

If you post your code people will be able to tell you what is wrong with it.

wddr

Jwreford wrote: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

Can you please post the code you're trying to get working?

krc

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

skyinan

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.

こ忘了隠藏ご

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

libo600

Jwreford wrote: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

Not sure where you gained the extra semicolon from but you need to take it out. I also missed a bracket from the end of the code i provided.

Code: ['IM ACC DATA Measures':'ACCURACY %']=N:If(['ABS ERROR']=0,1,If((['ABS ERROR']>0)&(['Forecast']=0),0,1-(['ABS ERROR']['FORECAST'])));