I used Table Builder to create a spreadsheet and tried to get it to caclulate a couple columns. I want the result of Line amount divided by Qty. It let me create it but gives me an error when I try and run it. Can you tell me what I need to do to fix it? =NP("Formula","[@[Amount]]/[@[Quantity]]")
Error
An error occurred populating the Excel table with the requested data. Ensure that all formulas in calculated columns are valid.
It is the only formula.
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Marti,
What's the exact version of Jet and what version of Excel are you using? This sounds like an issue that existed in the Table Builder where it didn't create the column references correctly for earlier versions of Excel such as Excel 2003. If this is the case, then upgrading to the latest version of Jet should fix it. Does that help?
Regards,
Hughes
Please sign in to leave a comment.