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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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