User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
saitcopuroglu
saitcopuroglu
Level IV

JSL: Can I call data from another data table? Make formula calculations based on a different data table rather than the actual?

Apr 28, 2015 08:50 AM (4139 views)

Hi All!

I need to report 3 different structured data tables (budget, income, crm) in one report which urges me to call data from 3 different data tables. Is it possible?

Let's say I need to make a formula ColSum of dt1,byvariable / ColMean dt2, byvarieble to beplaced at dt3 ?

0 Kudos
1 REPLY 1
pmroz
Super User pmroz
Super User

Re: JSL: Can I call data from another data table? Make formula calculations based on a different data table rather than the actual?

Apr 28, 2015 09:14 AM (4066 views)  |  Posted in reply to message from saitcopuroglu 04-28-2015

If you need to make a column formula you could join the tables with the JOIN command.  Or update a main table with supplementary information from a secondary table using the UPDATE command.

Recommended Articles