I am getting invalid field formulae error while trying to import or open the sheet in workbook. Please help me out.
I tried creating new datasource and replacing. But its not working. When i try to remove 2 fields its working fine. But i am unable to understand whats wrong with the calculated fields.
Workbook working fine since morning. Suddenly facing this issue.
sum([Current Procedure Value])+ (sum([Current Procedure Value])* [Product Price%]/100)
I am using:
sum([ Value])+ (sum([ Value])* [%]/100)
Calc 2: sum([ Value])+[$] where % and $ are parameters ranging from -5 to 25.