Unable to use formula in excel report in Webpay
To execute the formula in the excel sheet you need to change the format of the columns in the excel sheet to "GENERAL".
Select the whole sheet --> Right Click --> Format Cells --> Number --> Select General and Click OK. Now you would be able to execute the formulas. The excel sheet that is published is in Text Format because if the employee code is 0001, it would change to 1 in excel.
Remember if the employee code is like 0001 then do not change the employee code column format.
Blog by BBSPL
No comments:
Post a Comment