Subscribe Bookmark RSS Feed

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

saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

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 ?

1 REPLY
pmroz

Super User

Joined:

Jun 23, 2011

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.