replace missing values by an expression of another attribute (another attribute divided by 0,17)

HSan1971HSan1971 Member Posts: 2 Newbie
Hi everyone, I need to replace missing values in some attribute by an expression of another attribute. for instance: in attribute "total day minutes" I need to replace the missing values by "total day charge" divided by 0,17 

Best Answer

  • Options
    rjones13rjones13 Member Posts: 163 Unicorn
    Solution Accepted
    Hi @HSan1971,

    Simplest here is probably to use Generate Attributes. You can overwrite columns, so you would declare a column called "total day minutes", and the function would be:

    if(missing([total day minutes]),[total day charge]/0.17,[total day minutes])

    The if statement is used alongside the missing function to run the function if there's a missing value, else you state it should keep it's value.

    Hope this works for you.




  • Options
    HSan1971HSan1971 Member Posts: 2 Newbie
    Thanks a lot Roland for your help!
Sign In or Register to comment.