No value on total

[#1]

Hi everybody;

i have a issue, i have some value which are from a applymap, this is numeric number and i get it in "monetary" on the type of number.

But when i do a total that don't worK as you can see on attached file

do you know why?

Thanks a lot!

[MK_QSL]

Its very difficult to answer by only looking your JPG file. Kindly upload sample application or sample data!

[#3]

Hi ,

Post sample data for more help...

Try like below,

Go to Expression properties>Total mode>select Total

or

properties>Number>select calculated field>select Number format setting >Number

[amit_saini]

Sab,

Not sure if you are doing like below to get the sum total:

Thanks,

AS

[#5]

I posted it at the main post!

Thanks for your answers

[avinashelite]

Hi Sab,

The Issue is with the DATA , in your expression their are lot of null values because of this even the total is appearing as null, convert the null values to zero in the script and then try , the total column will get populate

Hope this helps you

[#7]

I tried it but it not work..

[#8]

HI

try with straight table it will work ,

Rather,

if we use pivot try like below if possible,

num(sum(objectif_synth)/10800,'# ##0,0 K€;-# ##0,00 €')

[avinashelite]

Did you handled the null values in the script? if not change the null values to 0 in the script level it will work

try changing the Pivot table to Straight table and then check?

[#10]

Sorry for all my questions because i'm a beginner ahah

but where i put this instruction "num(sum(objectif_synth)/10800,'# ##0,0 K€;-# ##0,00 €')"?
In the expression?