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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error in my if statement

 

sum

(if(Naedo = 'Naedo',((Naedo_Collection + Transfer + Catch_all)*(-1) +(NaedoCollectedthisMorning))/(Amount_due_actual),null

()))

11 Replies
Not applicable
Author

try replacing null() with 0

Not applicable
Author

Thank you. The percentages are too big, What could be the problem

Not applicable
Author

Thank you. The percentages are too big, What could be the problem

Not applicable
Author

Thank you. The percentages are too big, What could be the problem

Not applicable
Author

Thank you. The percentages are too big, What could be the problem

Not applicable
Author

Thank you. The percentages are too big, What could be the problem

Not applicable
Author

Thank you. The percentages are too big, What could be the problem

Not applicable
Author

the % age values depends on ur values of the dividend & divisor in the if statement?

if u cud post some sample values ?

Not applicable
Author

pls delete multiple posts