Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pgalvezt
Specialist
Specialist

Wrong Total Sum

Hello!

I have a set analysys that works fine but the total acummulate for months is wrong. I will expect -18 instead of -29.

Thanks!

1 Solution

Accepted Solutions
pgalvezt
Specialist
Specialist
Author

Done!

The Solution was put

Round(

Sum(Aggr(Formula),IdContable),2)

Thanks!

View solution in original post

3 Replies
simospa
Partner - Specialist
Partner - Specialist

Hi,

that isn't a set analysis but an expression with many nested if statement.

Do you want that your formula shows a different result concording with selection?

S.

pgalvezt
Specialist
Specialist
Author

Hi,

Thank you for your reply,

If you do clic on ene -7 show fine

If you do clic on feb -7 show fine until that my sum is correct (-14)

but if you do clic on mar show fine (-2) the total sum is wrong (show -22 instead of -16) and so on...


Thanks!

pgalvezt
Specialist
Specialist
Author

Done!

The Solution was put

Round(

Sum(Aggr(Formula),IdContable),2)

Thanks!