count syntax problems

[#1]

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?

Thanks for your help

[sdmech81]

May be like

ZeitIst = {'<=ZeitSoll'}

Your less than equal should go inside {}

Sachin.

[Anil_Babu_Samineni]

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

Try to do it in script

Load *,

%LaufnummerID & %ProzessID as %LaufProzID;

And then Use this as Expression

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

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

[#4]

Thank you very much for your help.

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

[rubenmarin]

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()'}".

Also it will be a good idea what Anil posted about loading the field in script.

[#6]

Dear all

Thank you very much for your respond. I solved because of you the Syntax issue and it worked.

sincerly Danny