# Exporting BAQ in csv by BAQ Export Process doesn't honor the format string of decimal type eg. \>\>\>9.99

**URL:** <https://www.epiusers.help/t/exporting-baq-in-csv-by-baq-export-process-doesnt-honor-the-format-string-of-decimal-type-eg-9-99/60838>\
**Category:** Epicor ERP 10\
**Tags:** baq\
**Created:** [October 16, 2019, 2:59am UTC](https://www.epiusers.help/t/exporting-baq-in-csv-by-baq-export-process-doesnt-honor-the-format-string-of-decimal-type-eg-9-99/60838 "2019-10-16T02:59:43Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![john009](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/c37758/32.png) [@john009](https://www.epiusers.help/u/john009)\
**Post date:** [October 16, 2019, 2:59am UTC](https://www.epiusers.help/t/exporting-baq-in-csv-by-baq-export-process-doesnt-honor-the-format-string-of-decimal-type-eg-9-99/60838/1 "2019-10-16T02:59:43Z")

</div>

Hi Expert,

1/Can you confirm there is a bug in BAQ Export Process dialogbox to export baq in csv which ignore the format string of decimal type as specified in the baq designer ?

The number is correctly formatted in the baq designer but when running BAQ Export Process or schedule it to export to csv, it doesn’t format the number properly.  
My epicor version is 10.1.600.3.

eg 1.000000, i just want 1.00  
0.0000000000000000, i just want 0.00  
using format string \>\>\>\>\>\>\>9.99 in baq designer

Note: I can do workaround like round the price to 2 decimal place and convert it to varchar and change the calculated field is from decimal to nvarchar ) in baq editor.

![image](https://epiusers.help/uploads/default/original/3X/f/1/f1eeb6908d456066be98a4612eeec04407b94c66.png)

---

<div class="post-metadata">

**Author:** ![surendrapal](https://www.epiusers.help/user_avatar/www.epiusers.help/surendrapal/32/6162_2.png) [@surendrapal](https://www.epiusers.help/u/surendrapal)\
**Post date:** [October 19, 2019, 4:33pm UTC](https://www.epiusers.help/t/exporting-baq-in-csv-by-baq-export-process-doesnt-honor-the-format-string-of-decimal-type-eg-9-99/60838/2 "2019-10-19T16:33:24Z")

</div>

I tested in 10.2.400.10, it working fine as you expected.

---

<div class="post-metadata">

**Author:** ![bordway](https://www.epiusers.help/user_avatar/www.epiusers.help/bordway/32/30753_2.png) [@bordway](https://www.epiusers.help/u/bordway)\
**Post date:** [October 20, 2019, 6:49pm UTC](https://www.epiusers.help/t/exporting-baq-in-csv-by-baq-export-process-doesnt-honor-the-format-string-of-decimal-type-eg-9-99/60838/3 "2019-10-20T18:49:00Z")

</div>

Might want to search for some specific solutions, I know there is at least one other thread discussing this(but I don’t have any E10Help links handy).

Basically users hav been using calculated fields when they need an exact format in their CSV.  
For number decimal places like you describe, I believe the trickwas in a calc field - build your number.decimals and then convert it to a string .

---

<div class="post-metadata">

**Author:** ![john009](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/c37758/32.png) [@john009](https://www.epiusers.help/u/john009)\
**Post date:** [October 20, 2019, 9:28pm UTC](https://www.epiusers.help/t/exporting-baq-in-csv-by-baq-export-process-doesnt-honor-the-format-string-of-decimal-type-eg-9-99/60838/4 "2019-10-20T21:28:38Z")

</div>

Thanks, My epicor version is 10.1.600  
I know how to do the workaround. I probably wouldn’t report the bug to epicor, since it is already fixed in 10.2

---

<div class="post-metadata">

**Author:** ![john009](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/c37758/32.png) [@john009](https://www.epiusers.help/u/john009)\
**Post date:** [November 7, 2019, 12:22am UTC](https://www.epiusers.help/t/exporting-baq-in-csv-by-baq-export-process-doesnt-honor-the-format-string-of-decimal-type-eg-9-99/60838/5 "2019-11-07T00:22:16Z")

</div>

I’ve found  
[https://epicorcs.service-now.com/epiccare?id=form&sys\_id=a309f945db1caf444fbe7aa9bf9619ce&table=problem&view=csp](https://epicorcs.service-now.com/epiccare?id=form&sys_id=a309f945db1caf444fbe7aa9bf9619ce&table=problem&view=csp)

At the bottom of the web page (development task), anyone know what is task number, pd system number, resolution number and where for me to look up those ids for more details.

Thanks Experts.