STRING_AGG Decimal Places

[Nick_Crow]

We are making a BAQ with the quantity per parent for each material in one cell. Our equation is as follows:

This is what we get as a result:

We have been searching for a way to only have 2 decimal places. The hard part is there are multiple numbers in one cell. We want each to have only 2 decimal places.

Any ideas? Any help is appreciated!

[Randy (Randy Stulce)]

Have you tried a Convert? Something like:

String_Agg( Convert(Decimal(10,2),JobMtl.QtyPer) ,', ') 

If that doesn’t work perhaps Format(JobMtl.QtyPer, ‘N2’) instead of the Convert command.

[Nick_Crow]

@Randy

String_Agg( Convert(Decimal(10,2),JobMtl.QtyPer) ,', ')

That was fast. This worked, thanks!