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