Incorrect Sum up

[#1]

Hello all,

I was working on a straight table in qlikview and came across this;

The total for Excess should be -264.61 but instead I'm getting 0.00

What could be the cause of this and how can I get the right figure?

Thanks

Fifi Nokoe

[MindaugasBacius]

Try doing this:

You should remember that this option is able only in Straight table.

[Frank_Hartmann]

can you share a sample?

[danansell42]

Hi Fifi

What is the expression you have used?

Is it possible the -264.61 is not actually formatted as a number?

Thanks

Dan

[sunny_talwar]

What is the expression used here?

[susovan]

Try this way,

I have used this below expression in this chart

Expression : if((Sum(Amount-Amount1))<0,'('& Sum(Amount-Amount1)& ')',Sum(Amount-Amount1))

[#7]

Hello Dan, Thanks for your response. This is the expression; IF(ov_ExpiryDate < TODAY(),COLUMN(1), IF(COLUMN(2)> FABS(COLUMN(1)),'', COLUMN(1) + COLUMN(2))) Column is money formatted and even when it's fixed to two decimal places it doesn't sum the column total

[nizamsha]

create a 2 field and check what format you are getting.

if Your value(-264) is aligned in leftside then you will get 0 only

replace that open and close bracket in the back end  and make that one as number like this 

PurgeChar(Amount,'()') as Amount

then do ur calculation it should work

[#9]

column 1 >>>> sum(Balance) column 2 >>>>SUM(IF(LEFT(ID_ID,2)='LD',(Balance) * -1,IF(LEFT(id_ID,2)<>'LD',limit))) Excess  >>>>>>>>>>>>> IF(expiry< TODAY(),COLUMN(1), IF(COLUMN(2)> FABS(COLUMN(1)),'', COLUMN(1) + COLUMN(2))) Column is money formatted

[nizamsha]

can you share excel so that we can check where was that gap