5 Replies Latest reply: Feb 24, 2017 4:49 AM by Daniele Imhof

# count syntax problems

Hello there

hope to place my question on the right place.....

I've got this expression wich doesn't work on a normal text field....

num(100 *(count({<ZeitIst <= {ZeitSoll},Prozessnummer ={'P2'}>}Prozessnummer))  /

(count({<Ende -= {'Null()'},Prozessnummer ={'P2'}>}%LaufnummerID&%ProzessID) ),0.00) &'%'

it works (Syntax check) when I canche it to:

num(100 *(count({<ZeitIst = {ZeitSoll},Prozessnummer ={'P2'}>}Prozessnummer))  /

(count({<Ende -= {'Null()'},Prozessnummer ={'P2'}>}%LaufnummerID&%ProzessID) ),0.00) &'%'

(it looks like I am using the wrong Operator <= for smaller equal).

any one an idea?

• ###### Re: count syntax problems

May be like

ZeitIst = {'<=ZeitSoll'}

Your less than equal should go inside {}

Sachin.

• ###### Re: count syntax problems

Try this and Can you describe more, What are these?

Try to do it in script

%LaufnummerID & %ProzessID as %LaufProzID;

And then Use this as Expression

Num((Count({<ZeitIst = {"<ZeitSoll"}, Prozessnummer = {'P2'}>} Prozessnummer))/

(count({<Ende -= {' '}, Prozessnummer ={'P2'}>} %LaufProzID)) * 100,'#,#0%')

• ###### Re: count syntax problems

Thank you very much for your help.

I will it try as soon as possible....

• ###### Re: count syntax problems

Hi, maybe:

num(100 *(count({<ZeitIst = {"<=ZeitSoll"},Prozessnummer ={'P2'}>}Prozessnummer))  /

(count({<Ende = {"*"},Prozessnummer ={'P2'}>}%LaufnummerID&%ProzessID) ),0.00) &'%'

The "<=" maybe should be an "<". And using double quotes the evaluate the condition.

The "*" is in case you want to filter all fields with any value not null(), if you are looking to remove the string 'Null()' keep your original "Ende -= {'Null()'}".