Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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!