From 597a7252c466097eb3a0f5abe7278e5b131cfee8 Mon Sep 17 00:00:00 2001
From: Christopher Burger <burgerc@freeside.biz>
Date: Thu, 30 Nov 2017 10:49:10 -0500
Subject: [PATCH] RT# 78019 - updated csv and excel export to set two decimal
 for revenue columns.

---
 httemplate/graph/elements/report.html | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/httemplate/graph/elements/report.html b/httemplate/graph/elements/report.html
index 70c3a9e94..6e6c382f6 100644
--- a/httemplate/graph/elements/report.html
+++ b/httemplate/graph/elements/report.html
@@ -52,10 +52,10 @@ any delimiter and linked from the elements in @data.
 %
 %   my @bottom_total = ();
 %   my $row = 0;
-%   foreach ( @items ) {
+%   foreach my $i ( @items ) {
 %
 %     my $col = 0;
-%     my @row = map { sprintf($sprintf, $_) } @{ shift(@data) };
+%     my @row = map { sprintf($sprintf_fields->{$i} ? $sprintf_fields->{$i} : $sprintf, $_) } @{ shift(@data) };
 %     my $total = sum(@row);
 %     push @row, sprintf($sprintf, $total) unless $opt{'nototal'};
 %     unless ($opt{'no_graph'}[$row]) {
@@ -101,7 +101,7 @@ any delimiter and linked from the elements in @data.
 %   }
 %
 %   my @bottom_total = ();
-%   foreach ( @items ) {
+%   foreach my $i ( @items ) {
 %     $row++;
 %     $col = 0;
 %     my $total = 0;
@@ -109,7 +109,7 @@ any delimiter and linked from the elements in @data.
 %     foreach ( @{ shift( @data ) } ) {
 %       $total += $_;
 %       $bottom_total[$col-1] += $_ unless $opt{no_graph}[$row];
-%       $worksheet->write_number($row, $col++,  sprintf($sprintf, $_) );
+%       $worksheet->write_number($row, $col++,  sprintf($sprintf_fields->{$i} ? $sprintf_fields->{$i} : $sprintf, $_) );
 %     }
 %     if ( !$opt{'nototal'} ) {
 %       $bottom_total[$col-1] += $total unless $opt{no_graph}[$row]; 
-- 
2.11.0