AnsweredAssumed Answered

ExecuteSQL drops zeros after decimal when extracting price information...

Question asked by productionQC on Jul 23, 2013
Latest reply on Jul 24, 2013 by philmodjunk

Title

ExecuteSQL drops zeros after decimal when extracting price information...

Post

      

     Hello -

     I am using the following calcuation to extract pricing information and display in columns.

     ExecuteSQL ( "SELECT Category, Sum ( Cost ) FROM Renovation GROUP BY Category ORDER BY 2 DESC" ; Char (9) ; "" )

      My problem is that SQL drops any zero's after pricing.  Thus they will not line up properly.  Does anyone know how to keep the zeros?

     Please see attached photo which illustrates the problem.  Notice that the top price has no ".00" after it causing it not to line up...

     Thanks

      

Voila_Capture44.png

Outcomes