0

Linked Filed Formula

Jet Reports Historic Posts

February 27, 2015 04:55

None

Follow

Hello

I need some help to add the linked field in the report to get the "country region name"

Attached the report - AR Customer sales by Sheet Dimension_Country_Ph, in this report I need the country name formula ( I understand we need to link the customer table and country region table )

Also attached other report just for noticing the what sort of table and fields we have for the country region, this is just for reference.

Please help

Best regards

Ravi - Hong Kong

• AR Customer Sales by Sheet Dimension_Country_PH.xlsx
• countywisecountrynameV7_AEL.xlsx

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts February 27, 2015 04:58

  Please see the file with field tile for the formula

  • AR Customer Sales by Sheet Dimension_Country_PH.xlsx
• 0
  
  Jet Reports Historic Posts February 27, 2015 05:07

  Hi
  
  Instead of using the linked field, I could get the country name using the NL first and reference the country code, I got what I wanted but I am not sure if this the best way to do this or any other alternative.
  
  Please comment.