cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mszarka
Level: Powered On

IF FUNCTION

Dear all,

I am looking for a solution to change text by value High to Low.

I have a value in Datacardvalue13 and I want to change the field if the number higher than 10000 to HIgh medium etc. Do you have any Idea why is it not working please? it says that invalid argument expecting numbers but I have changed to numbers all field.

thanks

1.jpg2.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
PauwelsSven
Level 8

Re: IF FUNCTION

Hi,

 

DataCardValue13 won't work because it is a record.

You need to take one of the properties, which will be .Text for a textvalue.

The Value function will make a number of it.

 

If(Value(DataCardValue13.Text) > 10000, "High")

 

Try to enter this formula in your destination textinput control under the property Text or Default.

5 REPLIES 5
PauwelsSven
Level 8

Re: IF FUNCTION

Hi,

 

Try to put Datacardvalue13.Value > 10000 or Value(Datacardvalue.Text) > 100000

mszarka
Level: Powered On

Re: IF FUNCTION

hi PauwelsSven

unfurtunatelly it is not working for me.Smiley Sad any other idea?

Value(Datacardvalue.Text) > 100000 I can input but there is no action or error and the text is not appearing.

Highlighted
PauwelsSven
Level 8

Re: IF FUNCTION

Hi,

 

Can you show me the formula you are using, also with the errormessage?

 

mszarka
Level: Powered On

Re: IF FUNCTION

Hi PauwelsSven

what I have tried it is on the picture If(DataCardValue13 > 10000, "High")

the error message was invalid argument type expecting a number value.

thanks

PauwelsSven
Level 8

Re: IF FUNCTION

Hi,

 

DataCardValue13 won't work because it is a record.

You need to take one of the properties, which will be .Text for a textvalue.

The Value function will make a number of it.

 

If(Value(DataCardValue13.Text) > 10000, "High")

 

Try to enter this formula in your destination textinput control under the property Text or Default.