jeudi 8 mars 2018

IF in sharepoint 2010

I create new column call "Normalization". It's Calculated filed(calculation based on other columns)

I try this formula:

=IF([Probability]="High",[Expected annual savings]*1,IF[Probability]="Low",[Expected annual savings]*0.25)

but it only shows "NO" in the field

any ideas?

Aucun commentaire:

Enregistrer un commentaire