IF not Working in a load

[#1]

HI,

i define in a load section a IF but i have an error that i don't understand

Load

          cas_id,

          if(note.devis=1, round(sum(note.temps_realise),1), 0) as fact_hors_devis,

but in the load i have a message that fact_hors_devis is not defined

Thanks

Cyril

[IAMDV]

Hi Cyril,

Please try with square brackets or "" surronding the field names. If this does not work please can you postthe complete script?

IF([note.devis]=1, Round(Sum ([note.temps_realise]),1), 0) as fact_hors_devis,

Thanks,

DV