I have a report based on a SQL stored procedure. In the stored proc I have created a formula to come up with a "number" that is totalling a statement amount (current_due+past_due). The formula I created is: convert(int, floor(total_due))
When I pull total_due into the report and browse the data, I see the data correct (zero decimal places), however, I am trying to convert this value to text so that I can add it to another formula. When I create a formula totext(total_due), the value is displaying 2 decimal places..I have not been able to eliminate the decimal places when I convert it to text..any ideas?
IP Logged
