Hello
I'm having trouble with a conditional statement referencing a 'V-String' type column, then using numeric column type 'Double' columns to calculate an Output in data type 'Double'.
The highlighted 'yellow' column is my required output, derived using the impact formulas.
My flawed formula is below and in attached workflow. I thought 'IF' statement with ''ToNumber' would be best way to go but keep getting a 'malformed error' and 3rd formula just doesn't compute.
Could someone please explain best way to use conditional statements based on a V-String type column, then using 'double' type columns to compute a math formula to give numeric (double type) output?
Stuck in the mud with this one sorry.
Thanks!
Sures
Solved! Go to Solution.
Hi @sureslala
I seem to have gotten this working, a few notes on what was wrong:
Thanks Luke looks like I was a little careless in my formulas and didn't pay enough attention to my data. Lesson learnt! thanks again. I've got my test example to work, will now hopefully apply same lessons to my main