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

[marcelviegas]

Is your logic right, can you post an example?

[Anonymous]

pls see the image Marcel

[marcelviegas]

check if  it TXT_EXPORT.ARGUMENT_13 this is a valid number

[Anonymous]

Hi Marcel it is a field, if the value of this field is greater than 10 then we have to replace by the value of other field BHP other wise show 1

[Anonymous]

Try this :

In script,

Load

num#(TXT_EXPORT.ARGUMENT_13)  as TestArguement;

num#(TXT_EXPORT.ARGUMENT_13,'###')  as TestArguement2;

In App

bring them in as objects. (Pls. Paste the results or any sample data on what you are trying to accomplish)

Thanks,

SP

[Anonymous]

Thanks SP will share raw date tomorrow thanks a lot