Logical issue

[Anonymous]

Hi all,

I have a requirement where if value of field X is greater than 10 then it should be replaced by values of other field Y.Otherwise show value as 1.I am applying a logic

if(X>10,Y,"1")

But it is not giving the values of Y For values greater than 10 instead giving  a string "PRAGNOS

Can anyone help me??

Regards

Adarsh

Message was edited by: adarsh chaubey

[prieper]

in script or expression?

can you please post an example?

[Anonymous]

Hi peter pls see the below image

[prieper · Accepted solution]

Would recommend to check the content of the field BHP.

Why do you choose NUM#(TXT_EXPORT.ARGUMENT_13) or NUM(BHP)? In most cases QV does not really differentiate betw strings and numbers.

Might be worth to have a tablebox with the inputvalues and the output and check for anomalies in the in input-data.

Peter