Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
My variable is this format = '# ##0,00'
NUM(DMBTR,'$(vFormat_Num)') as DMBTR,
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