Forum Discussion

pupadhya's avatar
pupadhya
Icon for Helper I rankHelper I
3 years ago
Solved

Custom 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...
Need Help
  • ronrsnfld's avatar
    ronrsnfld
    3 years ago

    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.

pupadhya's avatar
pupadhya
Icon for Helper I rankHelper I
3 years ago

Thank you. this is my data type: 

My requirement is if family column returns with 787 then it should perform that calculation and place it in custom column and if family column has A320 then it should perform different calculation which I will improvise. Thanks

ronrsnfld's avatar
ronrsnfld
Icon for Super User rankSuper User
3 years ago

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.

  • pupadhya's avatar
    pupadhya
    Icon for Helper I rankHelper I
    3 years ago

    Many thanks it worked.