topic JSL: Can I call data from another data table? Make formula calculations based on a different data table rather than the actual? in Discussions https://community.jmp.com/t5/Discussions/JSL-Can-I-call-data-from-another-data-table-Make-formula/m-p/12130#M11571 <HTML><HEAD></HEAD><BODY><P>Hi All!</P><P></P><P>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?</P><P>Let's say I need to make a formula ColSum of dt1,byvariable / ColMean dt2, byvarieble to beplaced at dt3 ?</P></BODY></HTML> Tue, 28 Apr 2015 12:50:03 GMT saitcopuroglu 2015-04-28T12:50:03Z JSL: Can I call data from another data table? Make formula calculations based on a different data table rather than the actual? https://community.jmp.com/t5/Discussions/JSL-Can-I-call-data-from-another-data-table-Make-formula/m-p/12130#M11571 <HTML><HEAD></HEAD><BODY><P>Hi All!</P><P></P><P>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?</P><P>Let's say I need to make a formula ColSum of dt1,byvariable / ColMean dt2, byvarieble to beplaced at dt3 ?</P></BODY></HTML> Tue, 28 Apr 2015 12:50:03 GMT https://community.jmp.com/t5/Discussions/JSL-Can-I-call-data-from-another-data-table-Make-formula/m-p/12130#M11571 saitcopuroglu 2015-04-28T12:50:03Z Re: JSL: Can I call data from another data table? Make formula calculations based on a different data table rather than the actual? https://community.jmp.com/t5/Discussions/JSL-Can-I-call-data-from-another-data-table-Make-formula/m-p/12131#M11572 <HTML><HEAD></HEAD><BODY><P>If you need to make a column formula you could join the tables with the JOIN command.&nbsp; Or update a main table with supplementary information from a secondary table using the UPDATE command.</P></BODY></HTML> Tue, 28 Apr 2015 13:14:06 GMT https://community.jmp.com/t5/Discussions/JSL-Can-I-call-data-from-another-data-table-Make-formula/m-p/12131#M11572 pmroz 2015-04-28T13:14:06Z