BookmarkSubscribeSubscribe to RSS Feed

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


Community Trekker


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 ?


Super User


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.