Formula: tried to apply numeric operator to string value

[Raghadhq]

i'm trying to apply a formula and with multi row formula and it shows this message ( Error: Multi-Row Formula (38): Parse Error at char(279): Formula: tried to apply numeric operator to string value )

[alexnajm]

@Raghadhq what is your input, formula, and expected output?

[Raghadhq]

below is my input and the desire outcome is numbers the input contains ( v-string and date time ) 

[alexnajm · Accepted solution]

@Raghadhq it is still hard for me to guess because I cannot see your actual input data, but my thought is that you should look at your operators like minus and divide, and make sure the columns that they are affecting our numeric. For example, is MTOW numeric? Is the column that you are outputting all of this to numeric?

I forget offhand, but you might also have to look at using datetimediff instead of minus in order to get differences between time. 

[Raghadhq]

perfect thanks i used the datetimediff and it worked!😁

[alexnajm]

Fantastic news!