Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
IF([Status]='Authorized', IF([field1]+[field2]<=0,0,([field3]/([field1]+[field2]))*100), Sum ([field4])) as [output],
I am getting an error. the first part of the script is to get the denominator to not equal 0.
Assistance is appreciated!!!!!
I see you have used Sum in your script. Do you have Group By Statement to go with it?
"I am getting an error." which error message?
Which QlikView version?
I see you have used Sum in your script. Do you have Group By Statement to go with it?