mercredi 17 février 2016

PowerPivot if statement data type conversion

I used an IF statement in PowerPivot to generate some results but it stores it as a text column and not numeric.

=IF(AND([Staff Age]>17, [Staff Age]<28),"1","")

If I cannot change it to a numeric column how would I adjust the IF formula so that if it is True it generates a random number?

Aucun commentaire:

Enregistrer un commentaire