hi @LucMeekes
I am passing array of equations into an Array
And then want to get this function in the form of matrix like below wherein A is the Matrix, which I want to pass to reference calculation worksheet, which is called within main worksheet.
It gives the error to check label.
Can anyone help me to understand and solve this.
I could do this in Mathcad 15 and now struggling in Prime.
Regards,
JK_9391805
ACCEPTED SOLUTION
Accepted Solutions
You are right that the behaviour of evaluating combined Boolean expression unfortunately has changed in Prime.
Mathcad used "short-circuit evaluation". This means that when three Boolean expressions are combined with OR, the first one is checked and if the result is "true" the others are not evaluated anymore because its clear that the whole expression must be "true".
Prime evaluates every single boolean and decides afterward about the result.
As you already noticed, the error occurs when the limit is a string because its not allowed to compare a string with a numeric value.
So given that this is the expression which throws the error
on way to avoid the error is to split it
another is to wrap the last Boolean expression which could throw the error in a try and catch
Guess the first way is better readable.
EDIT: It just came to my mind that there may be a problem with both suggestions if "min_limit" is a string but neither "-" nor "NA".
The first workaround would throw an error in this case which is the same behaviour as MC15 would show
The second suggestion would return "true" in this case. Change the "1" to "0" and it always will return "false" in this case.
Of course you would also have to apply similar changes for the other combined Booleans wherever this error could be thrown as well.
See here for a thorough explanation of short-circuit evaluation and also some pros and cons of using it. It does not help as there is no way to turn this feature on in Prime but the article may give a hint why PTC might have decided against using short-circuit eval (in case they really did this on purpose).
And you really claim that doing so worked in Mathcad 15? It doesn't !!
Don't use global definitions and it works OK
And then, why not simply
or
?
Was there any specific reason for using the global assignments?
@JK_9391805 wrote:
thanks for the response.
We need to pass the equation array to another worksheet for further calculations which is called within same worksheet,
thats the only reason of using global operator
I am not quite sure about the workflow you have in mind and why you think global assignments are necessary. It might be a matter of where in the worksheet the external file is referenced..
Of course your approach would also work if you use global assignment throughout. Not sure if this would be of help.
I am sharing only the function where i face the error, although it doesnt work in demo worksheet, its working at my clubbed sheet but I cant share 😞 see below snap for evaluation of all passed variables in PerformAnalysis function
As shared earlier, again this was working in MC15 and converted to prime 10 using XMCT converter. which didnt throw any error messages after conversion. maybe some syntax is not as per prime demand.
Can't say much.
Only expression in my opinion which may throw this error in the function you posted is the comparison in the if -statement
So you may check the result of the function "GetStepValueConfigInfo" and see if the element is a scalar.
On the other hand the error may also be thrown in one of the functions which are called in "PerformAnalysis".
You may try if Primes error trace facility is able to tell you where the error exactly occurs. Put the cursor at the error and then press "First".
You may need to split your if statement(s):
As you don't know in which order Prime is going to evaluate the test.
If it first tries to compare min-val with min-limit, nad min-limit is "-" then you get such error message.
First test if min-limit is "-" or "NA", then if that is not true, can you compare numeric values.
Success!
Luc
You are right that the behaviour of evaluating combined Boolean expression unfortunately has changed in Prime.
Mathcad used "short-circuit evaluation". This means that when three Boolean expressions are combined with OR, the first one is checked and if the result is "true" the others are not evaluated anymore because its clear that the whole expression must be "true".
Prime evaluates every single boolean and decides afterward about the result.
As you already noticed, the error occurs when the limit is a string because its not allowed to compare a string with a numeric value.
So given that this is the expression which throws the error
on way to avoid the error is to split it
another is to wrap the last Boolean expression which could throw the error in a try and catch
Guess the first way is better readable.
EDIT: It just came to my mind that there may be a problem with both suggestions if "min_limit" is a string but neither "-" nor "NA".
The first workaround would throw an error in this case which is the same behaviour as MC15 would show
The second suggestion would return "true" in this case. Change the "1" to "0" and it always will return "false" in this case.
Of course you would also have to apply similar changes for the other combined Booleans wherever this error could be thrown as well.
See here for a thorough explanation of short-circuit evaluation and also some pros and cons of using it. It does not help as there is no way to turn this feature on in Prime but the article may give a hint why PTC might have decided against using short-circuit eval (in case they really did this on purpose).
