Hi,
I am new to this so appolgise for any ignorance. I have a new Jet report (created from Table Builder) that uses sumif formulas on another tab of the workbook.
When I refresh the report, all the formulas are lost (references are #REF). I presume this is because the columns ar deleted and repopulated as part of the refresh. I tried named ranges but they did not work either.
Surely there is a way around this otherwise no excel formulas are possible?
Thanks
Date
Votes
3 comments
-
Jet Reports Historic Posts Hello,
As far as I know, Excel formulas are not supported with Jet Express.
Elena -
Jet Reports Historic Posts You may be able to "build" cell references and then use Excel's =INDIRECT() function, but you would have to know the exactly cell where your data is located.
-HP -
Jet Reports Historic Posts Jet Essentials includes the ability to add calculated values to the tables, but not Jet Express.
Please sign in to leave a comment.