# Calc formula in kreporter csv export?

**URL:** <https://community.spicecrm.io/t/calc-formula-in-kreporter-csv-export/214>\
**Category:** Uncategorized\
**Created:** [November 22, 2017, 7:06pm UTC](https://community.spicecrm.io/t/calc-formula-in-kreporter-csv-export/214 "2017-11-22T19:06:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![transpalette](https://avatars.discourse-cdn.com/v4/letter/t/e9a140/32.png) [@transpalette](https://community.spicecrm.io/u/transpalette)\
**Post date:** [November 22, 2017, 7:06pm UTC](https://community.spicecrm.io/t/calc-formula-in-kreporter-csv-export/214/1 "2017-11-22T19:06:47Z")

</div>

Hi, i need help to use calc formula into csv export ?

My screenshot : calc & csv export

how to use formula ?

 ![0_SuiteCRM](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/16e808bc8898492d4747ae07b7ecb8eb0fd2eaee.png)

And how to remove € in csv export ?

Thank you 🙂

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [November 24, 2017, 4:06pm UTC](https://community.spicecrm.io/t/calc-formula-in-kreporter-csv-export/214/2 "2017-11-24T16:06:05Z")

</div>

store the variable (give it a name).  
In my example I store the amount in total  
In formula you may use php syntax, meaning php functions, or simply opertors like +, - / or \*, brackets.

 ![formula](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/8fa3d247468ffd1ebe7afa10523bf072cefc680c.PNG)  
Please note how to use the stored variable in formula using { } : {total} in my example

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [November 24, 2017, 4:08pm UTC](https://community.spicecrm.io/t/calc-formula-in-kreporter-csv-export/214/3 "2017-11-24T16:08:57Z")

</div>

Regarding currency symbol: do you use overrideType in present tab? If you specified a currency type, then currency symbol will be exported. Use overridetype number, integer or do not format.

---

<div class="post-metadata">

**Author:** ![transpalette](https://avatars.discourse-cdn.com/v4/letter/t/e9a140/32.png) [@transpalette](https://community.spicecrm.io/u/transpalette)\
**Post date:** [November 25, 2017, 10:10am UTC](https://community.spicecrm.io/t/calc-formula-in-kreporter-csv-export/214/4 "2017-11-25T10:10:37Z")

</div>

![ods_LibreOffice_Calc](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/b8292ee8caa9863311ade0f1195feccecd39e743.png)

ok for remove € in my export 🙂

for formula and php syntax, i need more detail please 😅

I need  
column “%” \* column “presta” (how i can transform 90% to 0.9 ?)  
And  
column “Maint” /12_ **11** (12 = total month & 11=november)  
i need to store the month of edition in a variable (november today, and soon december for Maint/12_12)

And SUB TOTAL for both ?

Thanks a lot maretval

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [November 25, 2017, 8:03pm UTC](https://community.spicecrm.io/t/calc-formula-in-kreporter-csv-export/214/5 "2017-11-25T20:03:19Z")

</div>

transpalette,  
assuming that % contains 90, you get 0.9 by doing 90/100  
Add a fixed field to display your subtotal

 ![formula02](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/8e589733dc88b3d893dc783f6a88c731494f4c09.PNG)  
For the rest I don’t understand what you need.

We provide KReporter Support against fee, contact me at [valerie.maret@twentyreasons.com](mailto:valerie.maret@twentyreasons.com) (in French if you like) for further support.

Val