JSL: Can I call data from another data table? Make formula calculations based on a different data table rather than the actual?<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />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 ?
Re: JSL: Can I call data from another data table? Make formula calculations based on a different data table rather than the actual?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.