Hi Community!
When using the SUM in the Summarize tool on adding dollar amounts, if the total amount is 10.40 or 10.00, the 0s are not pulling in. How can I keep both digits regardless of the of 0 or not?
Thank you!
Solved! Go to Solution.
@rockeylearning One way is to add a select tool after summarize tool and change datatype to fixed decimal
I agree with @MilindG - just to add that you can also change the data type to fixed decimal at the beginning of the workflow so it's flowing through consistently.
If I understand correctly, you want to preserve the presentation format after rendering to report?
In this case, I think the safest is to use select tool to format the numeric as fixed decimal and then right before feeding the data to ender report, convert the numeric to string.
ToString(10, 0) returns 10 as a string.
ToString(10.4, 2) returns 10.40 as a string.
ToString(100.4, 2) returns 100.40 as a string.
ToString(1000.4, 2, 1) returns 1,000.40 as a string.
ToString(123456.789, 3, 1, ",") returns 123.456,789 as a string.
ToString(123456.789, 3, 0, ",") returns 123456,789 as a string.
ToString(1234567.89, 2, ".", ",") returns 1.234.567,89 as a string.
ToString(1234567.89, 2, " ", ",") returns 1 234 567,89 as a string.
ToString(1234567.89, 2, "'", ",") returns 1'234'567,89 as a string.
Dawn.
@MilindG @Bren_Spill @DawnDuong your suggestion worked, using the FixedDecimal. I am able to get what I need in the result