any suggestion on how to resole above error
Looks like the line item you are referencing in a SUM, SELECT or LOOKUP formula is Text or Number formatted. Change the line item that is being referred to so that it is LIST or DATE formatted. If it is currently TEXT then a FINDITEM might be helpful.
Thanks, it worked 👍