Parse error when trying to use IF formula to create ageing bucket using ageing days

Sujitra_Rajan

Hi guys,

I'm trying to create a new column with ageing bucket info using the ageing days column. I keep seeing this 'Parse error' message. 

Have attached screenshot of workflow & raw data.

Many thanks and appreciate your help with this.

Regards,

Sujitra  

AFFT Ageing day workflow snapshot.png

Data_raw.xlsx

ShankerV

Hi @Sujitra_Rajan 

This is due to the data type issue.

Solution 1: Change the datatype of the column Ageing days to Integer.

In this formula, please change the type.