Forum Discussion

fayanan's avatar
fayanan
Frequent Visitor
5 years ago

Replace null values in date column

Hi I have a column with promised delivery dates. The Excel sheet I'm importing this data from has some blank values for this column which are coming in as null values which is messing up my calculati...
Need Help
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi,  fayanan 

It is unnecessay to replace the blank value in 'proposed delivery dates'.

You just need to consider using t "if" function to discuss the situation.

 

delay in delivery =
IF (
    ISBLANK ( [proposed delivery dates] ),
    BLANK (),
    [proposed delivery dates] - [actual delivery date]
)

 

Best Regards,
Community Support Team _ Eason