Forum Discussion

SkaistePapuskai's avatar
SkaistePapuskai
New Member
10 years ago

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...
v-micsh-msft's avatar
v-micsh-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Hi SkaistePapuskai,

 

I tried the round function and it works, please try the formula when creating the column:

Column = if(value(Sheet1[Sales])<>round(Sheet1[Sales],0)&&value(Sheet1[Sales1])<>round(Sheet1[Sales1],0),

                  Sheet1[Sales]-Sheet1[Sales1],

                   0)

See the result:

If any further help needed, please feel free to post back.

Regards