Adding two SUMS together in a presentation

rob_h7

This is probably a silly question, but right now I have a presentation set up to calculate two totals determined by a date range and a company, fees.managementfee and fees.royaltyfee

Now, at the bottom of the presentation I have a grand total, which is just the SUM of the two totals for the above two attributes added together...simple enough really.

The tag expression I have to determine this is below...

'$'+(SUM Fees.ManagementFee WHERE (Fees.CreateDate>=FeeReport.DateFrom AND Fees.CreateDate<=FeeReport.DateTo AND Fees.FranchiseeName=FeeReport.Test1.FranchiseeName))+(SUM Fees.RoyaltyFee WHERE (Fees.CreateDate>=FeeReport.DateFrom AND Fees.CreateDate<=FeeReport.DateTo AND Fees.FranchiseeName=FeeReport.Test1.FranchiseeName))

Now, this isnt adding together the two totals, it's merely combing them into one long number. Ie, if management fee = $250.75 and royaltyfee = $150 then under Grand Total I get $250.75150

Any idea's how I can just add the two totals together?

Cheers.

bartthefish

What is happening is that it is treating the numbers as strings. this is due to the '$' being added as a prefix

Rather change your rule to the following

'$'+AS_STRING((SUM Fees.ManagementFee WHERE (Fees.CreateDate>=FeeReport.DateFrom AND Fees.CreateDate<=FeeReport.DateTo AND Fees.FranchiseeName=FeeReport.Test1.FranchiseeName))+(SUM Fees.RoyaltyFee WHERE (Fees.CreateDate>=FeeReport.DateFrom AND Fees.CreateDate<=FeeReport.DateTo AND Fees.FranchiseeName=FeeReport.Test1.FranchiseeName)))

This will 1st calculate the total before converting it to a string and adding the '$' prefix

rob_h7

Excellent, thanks for the help mate, works like a charm.

rob_h7

I have another question in regards to this.

Grand total is now working fine, however it seems to be calculating to about 8 decimal points. How do I get it down to 2?

eg, it's currently displaying, 403.35 + 300.65 = 704.4546452

Cheers,

Rob

bartthefish

I should have thought of this earlier as i use this all the time in my reports. If you change your tag to the following:

(SUM Fees.ManagementFee WHERE (Fees.CreateDate>=FeeReport.DateFrom AND Fees.CreateDate<=FeeReport.DateTo AND Fees.FranchiseeName=FeeReport.Test1.FranchiseeName))+(SUM Fees.RoyaltyFee WHERE (Fees.CreateDate>=FeeReport.DateFrom AND Fees.CreateDate<=FeeReport.DateTo AND Fees.FranchiseeName=FeeReport.Test1.FranchiseeName)),$ #.00

The $ #.00 tells the tag in what format to display the number.

Please let me know if this helps

RLJB

Hi Justin

I just tried:

AS_STRING(SUM Invoices.TotalIncGST WHERE (MONTH (Invoices.InvoiceDate)=1 AND YEAR (Invoices.InvoiceDate)=CURRENT_YEAR-1)),$ #.00

and it sums correctly but I still get the 8 decimal points and no $ sign

then I tried:

(SUM Invoices.TotalIncGST WHERE (MONTH (Invoices.InvoiceDate)=1 AND YEAR (Invoices.InvoiceDate)=CURRENT_YEAR-1)),$ #.00

and it outputs "$ .00" rather than doing a sum

which is the same also when I try:

SUM Invoices.TotalIncGST WHERE (MONTH (Invoices.InvoiceDate)=1 AND YEAR (Invoices.InvoiceDate)=CURRENT_YEAR-1),$ #.00

What am I doing wrong?

Thanks

Rod.

bartthefish

Hi Rod

Can you please enlighten me as to the format of Invoices.TotalIncGST is.
This may have a bearing on the problem.

Also what build of AwareIM are you using?

RLJB

Hi Again

Build is 1280

Format of Invoices.TotalIncGST is $#,##0.00

Maybe that is causing the problems huh?

Thanks

Rod.

RLJB

Ok, I removed all formatting from the TotalIncGST attribute and tried all combinations, still the same problem as above. Dang!