I'm trying to add the item number to the sample report mentioned in the subject. I'm able to insert a column next to the item description and add the field by copying the text from the cell that contains the description and just changing it to look for No. instead. When I refresh the report I see the item number and everything seems to be fine until I switch to one of the tabs that contains the "Profit Amount" and those cells are populated with #NAME?. The same thing happens when I try to add the customer number to the Sales Dashboard report so I guess I'm messing up a formula somewhere when I add the column. Below is an example of what I entered in the item number cell.
LinkField([27 Item],[No.])
Any idea how I can add a field without this happening? Any assistance would be greatly appreciated.
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello iminthezone,
Attached you will find a copy of the report with the added Item No. and #NAME?'s resolved.
When you modify the structure of the source table you will need to fix the Pivot Table's calculated fields from the Pivot Table Tools > Fields, Items & Sets > Calculated Field…
Best regards,
MWilson -
Jet Reports Historic Posts Thank you very much.
Please sign in to leave a comment.