Calc formula in kreporter csv export?

[transpalette]

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

My screenshot : calc & csv export

how to use formula ?

And how to remove € in csv export ?

Thank you

[maretval]

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.

Please note how to use the stored variable in formula using { } : {total} in my example

[maretval]

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.

[transpalette]

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” /1211 (12 = total month & 11=november)
i need to store the month of edition in a variable (november today, and soon december for Maint/1212)

And SUB TOTAL for both ?

Thanks a lot maretval

[maretval]

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

For the rest I don’t understand what you need.

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

Val