My values don't show after I do a sum

[Kaoutar_Lanjri]

Hello

I have table that has numerical values

this is is how the data was configured on the script

so as soon as i try to the sum on the data viz it does this

[Or]

Are the values contained in DMBTR actually numeric coming in? If they are coming in as text, you should be using num#() to convert them.

[Mark_Little]

To support what Or has said I would advise adding a the dimension to a table to make sure the data is coming through as expected. 

[Kaoutar_Lanjri]

My  variable is this format =  '# ##0,00'

 NUM(DMBTR,'$(vFormat_Num)')			as DMBTR,

[Kaoutar_Lanjri]

it is as i showed the first table it's BSEG.DEBIT as soon as add the second column next to it it makes an error