Re: Combining 2 Expressions

Eoj_VT · 12-31-2021 04:53 AM

Happy New year,

I would like to ask for help. I am working with an expression like below: I would like to combine this 2 formula. However im getting some error.

If([DATE] >="01/01/2022,[Type]<>"Fuel ",[Amount]*0.10/1.10,“0”)

If([DATE] <"01/01/2022,[Type]<>"Fuel ",[Amount]*0.05/1.05, “0”)

Thank you for help.

stilllifemuseum

Did you try using the IFS () expression?

IFS()

WillowMobileSys

You need to use AND() when there are 2 criteria you need to check.
There is a quote missing after the date.
Is there a reason there is a space after Fuel? If worried about spaces then use the TRIM() function.

Try this expression:

If( AND([DATE] >="01/01/2022", TRIM([Type]) <> "Fuel"),
    [Amount]*0.10/1.10,
    [Amount]*0.05/1.05
)

Eoj_VT

Thank you it works. However if the [type] =“Fuel Charge” is my issue. I would like if the user select fuel charge then this row value is automatically zero

WillowMobileSys

There are a couple ways. You could just wrap the IF() expression above with another IF().

I would lean towards the suggestion by @stilllifemuseum to use an IFS().

Based on what you have presented, I would create the IFS() like this:

IFS(
   AND([DATE] >= "01/01/2022", TRIM([Type]) <> "Fuel Charge"), [Amount]*0.10/1.10,
   AND([DATE] < "01/01/2022", TRIM([Type]) <> "Fuel Charge"), [Amount]*0.05/1.05,
   TRUE, 0.00
)

Eoj_VT

Your amazing thanks for help.