Method Community

We have a few items where it is necessary for us to invoice the Unit price down to fractions of a penny. So for example, $0.0243 per gram and $0.01856 per gram. This works fine within Method since we can go as many decimal places as we need in that field, but when we print the invoice in report designer, it rounds to $0.02 for both scenarios. It's just a handful of items that require this, so we still want two decimal places to show up as the default when we print in all other cases.

Question: Is it possible in report designer to format the label for Unit Price so that it expands if the field has more than 2 decimal places, but reverts to the default of 2 decimal places if the number in the field has 2 or less decimal places?

Thanks,
Andy

Andy-

You can use a format string like the following {0:#.00###}

This will show at least 2 decimal but up to 5 if needed.

-Michael

Andy-

One last detail-

If you want a $ use {0:$#.00###}

-Michael

Beautiful. Thank you, Michael.