Answered

If function returning error "Invalid argument type. Expecting a Number value."

Like (0) Share

Report

Posted on 13 Oct 2020 19:31:42 by Gorilla_8

I have a dropdown field called: "DataCardValue47" and it contains numbers from: 01 to 24, and I want other fields to appear if the value is less than or equal to the value selected in the "DataCardValue47" field.

My code:

If(DataCardValue47.Selected.Value= Value(DataCardValue13.Text)<=23;true;false)

An example:

I have a field called: "ValorDaParcela23", and the value in the field "DataCardValue47" is equal to: 23 or less it shows, if not, no.

Categories:

AI Builder

Mobile App

Connectors

Using Apps Using Formulas

I have the same question (0)

All responses (6)

Answers (1)

Gorilla_8 on 13 Oct 2020 at 20:12:24

Like (1)

Report

Re: If function returning error "Invalid argument type. Expecting a Number value."

I knew this error, but I didn't know where to put it, my head stopped here.

I thank everyone in this post for their help and understanding!

Thank you very much!

@RandyHayes , @VijayTailor and @eka24 !

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,287 Super User 2024 Season 1 on 13 Oct 2020 at 20:09:57

Like (1)

Report
Re: If function returning error "Invalid argument type. Expecting a Number value."

@Gorilla_8

As you mention the values are 01 through 24, this tells me your values are all text.

So your formula should be:

Value(DataCardValue47.Selected.Value)<= 23

You don't need all the If...true, false stuff. This formula will already return true or false.

I hope this is helpful for you.

Was this reply helpful? Yes No
Gorilla_8 on 13 Oct 2020 at 20:09:21

Like (0)

Report

Re: If function returning error "Invalid argument type. Expecting a Number value."

An example:

If(DataCardValue47.Selected.Value<=23;true;false)

Was this reply helpful? Yes No
Gorilla_8 on 13 Oct 2020 at 19:50:18

Like (0)

Report

Re: If function returning error "Invalid argument type. Expecting a Number value."

Yes, I tried both conditions, but I have a DROPDOWN with number values between 01 to 24 and I want to place a condition as it selects one of the options, understand?

Thnaks for the help @VijayTailor and @eka24

Was this reply helpful? Yes No
Vijay Tailor 2,961 on 13 Oct 2020 at 19:47:09

Like (0)

Report

Re: If function returning error "Invalid argument type. Expecting a Number value."

Hi @Gorilla_8 ,

As i can see you are passing two conditions invalidation part that is the reason you getting error.
Below screenshot for ref.
Note - if you want to use more condition then use the nested if.

Thanks,
Vijay

Was this reply helpful? Yes No
eka24 20,921 on 13 Oct 2020 at 19:45:23

Like (0)

Report

Re: If function returning error "Invalid argument type. Expecting a Number value."

If(DataCardValue47.Selected.Value>= Value(DataCardValue13.Text);true;false)

Or

If(DataCardValue47.Selected.Value=<Value(DataCardValue13.Text);true;false)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No