In one of the case when I am using lookup to get the required value based on the match found. So when I lookup not sure whether I need to use ROUND,CEIL, etc...Since the values are in different format(as shown below).For your information when I look it up we use to divide the original value and then it has to be formatted to so that it is any of the below so that match is found in mapping table(values in the below mapping table is already divided). Not sure how to manage the different formatting. please help.
I think it would be good to see all your indata, to get the full picture. you have one Excel file (with START and END), and then the mapping table in your first post, right?
This block didn't work. It is giving null for few of the records. Not sure what is going wrong here. Also wherever 1.0 is expected it is giving 1.00. Please help
Sorry for late response. Due to security reasons I will not be able to attach the sample data.
Thank you so much for your kind help. I think above block is working fine after removing the FLOOR but need to do through testing once. Will keep you updated on the same.
