Forum Discussion
pupadhya
Helper I
Helper ICustom Column
Hi All, I am trying to create custom column and the desired result is = from my column 'Family' if the value is 787 then custom column should calculate (5.5*16)+(5.5*40) = it should show the calc...
As I wrote and suspected, your 787 appears to be a number. Change your if statement so that you are comparing to the number 787 and not to the text string 787.
ronrsnfld
Super User
Super UserDid you see the error message: We cannot apply operator * to types Logical and Number.
Did you try editing your code to avoid that?
if ([Family] = "787") then ((5.5 * 16) + (5.5 * 40)) else 0