[development-axapta] Select Sum n Rounding in Axapta ???

[david santoso]

Hi All,... i'm beginner on axapta 3.0 sp3

I'm gonna design report with rounding value.

Does Anybody Know the syntax Sqlserver <Select Sum with Rounding >using on 
Axapta,

Now i'm using select syntax like this :

while select SumTaxMST from CustInvoiceJour_1 where 
CustInvoiceJour_1.TaxGroup == 'PPNK-2' && CustInvoiceJour_1.ClosePeriod == 6
{
SumTaxB += round(CustInvoiceJour_1.SumTaxMST,1);
}


i know it's better, if the syntax like this :

select sum(SumTaxMST) from CustInvoiceJour_1 where 
CustInvoiceJour_1.TaxGroup == 'PPNK-2' && CustInvoiceJour_1.ClosePeriod == 
6;

But the value of sum is not rounding,...

Plz tell me the right syntax....
thx in advance,

David Santoso


[Non-text portions of this message have been removed]






    


  
  
    SPONSORED LINKS
  
          
                  
            
        Computer part
      
                      
        Programming languages
      
                      
        Microsoft axapta
      
              
                        
            
        Support exchange
      
                    
           
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.