|
Re: Aggregating data from two different data sets [message #716264 is a reply to message #716251] |
Tue, 16 August 2011 19:47 |
|
Take a look at the attached example that aggregates across two tables.
If you just want to call java to get the days in a month use an
expression like:
importPackage(Packages.java.util);
cal = new GregorianCalendar();
cal.setTime(new Date());
days = cal.getActualMaximum(Calendar.DAY_OF_MONTH);
Jason
On 8/16/2011 3:24 PM, Rory wrote:
> Hello,
>
> I'm trying to create a sales report with extrapolated sales. I have two
> data sets, both have the same data source. I created a data set that
> just gives the number of business days into the month. I then have a
> data set that has the current months sales. I want to take the total of
> the months sales, which i got using an aggregation function, and divide
> it by the number of days into the month to get the average sales per day.
> any help is appreciated.
>
> Thanks
|
|
|
|
Powered by
FUDForum. Page generated in 0.03735 seconds