Forum Discussion
integer numbers for new column calculation
Hi, I have a small issue: my dataframe contains two columns - OrderedQuantity and DeliveredQuantity which contains decimal and integer values. I need to make a new column like this: =0 in those row...
SkaistePapuskai Created calculated column as below,
= IF( IFERROR(SEARCH(".",YOUR COLUMN),0) > 0, RESULT IF DECIMAL, RESULT IF INTEGER )