Compare two numbers using a IF statement

Like (0) Share

Report

Posted on 23 Aug 2023 07:19:31 by BCWdesign

I have a simple form and what to compare 2 values

If(TotalComp>TotalMonths,"Yes","No")

This is what I think the value should be but it does not work

When the user enters a DOB this calculates the age into months as a label This is TotalMonths

If (DateDiff (Today (), Date (Year (Now ()), Month (DataCardValue1.SelectedDate), Day (DataCardValue1.SelectedDate))) <= 0, DateDiff (DataCardValue1.SelectedDate, Today (),TimeUnit.Months),DateDiff (DataCardValue1.SelectedDate, Today (),TimeUnit.Months) - 1)

I then have a 2nd label which is the calculation of their comprehension age This is TotalComp

Sum(DataCardValue7*12 + DataCardValue8)

Categories:

General Questions

All responses (5)

Answers (2)

LaurensM 12,510 Super User 2025 Season 1 on 23 Aug 2023 at 10:16:47

Like (0)

Report
Re: Compare two numbers using a IF statement

@BCWdesign,

To auto-fill a choice column in a Form you will need to write the code in the DefaultSelectedItems property. In case the error occurs there as well, would it be possible to provide some additional info:

What is the exact error when hovering over the red lining?

What is the Items property of the combobox?
Verified answer

BCWdesign 56 on 23 Aug 2023 at 09:15:48

Like (0)

Report
Re: Compare two numbers using a IF statement

That works perfectly : )
How would I adapt it for a dropdown box? or as part of a form?

If( Value(TotalComp.Text) > Value(TotalMonths.Text), {Value: "Yes"}, {Value: "No"} )
Verified answer

LaurensM 12,510 Super User 2025 Season 1 on 23 Aug 2023 at 07:53:38

Like (0)

Report
Re: Compare two numbers using a IF statement

@BCWdesign if you want to visualize it in a label or textinput, we will need to make a slight adjustment:

If( Value(TotalComp.Text) > Value(TotalMonths.Text), "Yes", "No" )

Could you give this a try? 😊
BCWdesign 56 on 23 Aug 2023 at 07:47:14

Like (0)

Report

Re: Compare two numbers using a IF statement

Thanks still having issues with the type here is what happens
LaurensM 12,510 Super User 2025 Season 1 on 23 Aug 2023 at 07:34:16

Like (0)

Report
Re: Compare two numbers using a IF statement

Hi @BCWdesign,

If the combobox is a choice field please try (DefaultSelectedItems property):

If( Value(TotalComp.Text) > Value(TotalMonths.Text), {Value: "Yes"}, {Value: "No"} )

When comparing control values, always extend the control name with the property you would like to reference (e.g. .Text). Additionally, when comparing numbers within a label or text input use the Value() function.

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!