Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like
ZeitIst = {'<=ZeitSoll'}
Your less than equal should go inside {}
Sachin.
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%')
Thank you very much for your help.
I will it try as soon as possible....
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.
Dear all
Thank you very much for your respond. I solved because of you the Syntax issue and it worked.
sincerly Danny