Is it possible to sort my report by a calculated field in design mode?
For example: I have Sales Price in G5 and Cost of Goods sold in H5. Cell I5 = G5-H5. I would like to sort my report by Cell# I5 to see the items sold with highest Gross Margin.
Thank You
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
The answer is, yes it is possible, but not in the way you are thinking. You can only sort within the replicator formula itself (NL(Rows) probably). What does your NL(Rows) formula look like? Are the Cost of Goods Sold and Sales Price retrieved using NF functions from that formula or something else?
Regards,
Hughes
Please sign in to leave a comment.