1) Is it possible to give a table an alias in an NL Table function? For example, I want to inlcude the NAME of the dimensions used in a transaction. this necessitates referencing the Dimension Value table more than once, but this causes an error. The normal way to accomdate this is to use an alias for one instance to the table.
2) I need to do calculations based on the resulting data table, but Express does not seem to support this. Is there another way to accomplish this?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
1. I'm not sure exactly what you mean. What does your NL(Table) function look like and what error are you getting exactly? Jet Reports is not SQL so the answer is no, it is not possible to give a table an alias. However, it should be possible to reference a table more than once in a function, but I'm not sure exactly what you're doing.
2. When you say calculations, do you mean that you want columns of Excel calculations in your table based on other table values? You will have to upgrade to Jet Essentials in order to create calculated columns (using the "Add Formula" button in the Table Builder for example).
Regards,
Hughes
Please sign in to leave a comment.