Sorry for the confusion! My goal is to being able to override this formula, but I would like to have the override argument an "optional" thing. Therefore, when I leave "[Reimburse amount override]" empty, I would like to have the formula work as it is.
This is the original formula ( it works properly)
If([Category Requires # of 1-Way Trips Field],
If([Category - Multiplied by Mileage],
([# of 1-Way Trips] * [Category Rate]) * [Resource' Commuter Miles 1-way],
([# of 1-Way Trips] * [Category Rate])
),
[Mileage Cost]+[Cost]
)
I created a new currency field called "Reimburse amount override" and then I added to the main form. And then I came up with the following formula;
If([Reimburse Amount Override]>=0,[Reimburse Amount Override],
If([Category Requires # of 1-Way Trips Field],
If([Category - Multiplied by Mileage],
([# of 1-Way Trips] * [Category Rate]) * [Resource' Commuter Miles 1-way],
([# of 1-Way Trips] * [Category Rate])
),
[Mileage Cost]+[Cost]
))
Now the override works fine, but the problem is when I put so "cost", and I leave "Reimburse Amount Override" blank , the formula won't work anymore!
------------------------------
Michael Naser
------------------------------
Original Message:
Sent: 03-17-2022 12:36
From: Mark Shnier (YQC)
Subject: Working on Nested if Statement
Can you say in plain english words what the logic is. It's hard to help debug if we don't know your intent.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
Original Message:
Sent: 03-17-2022 12:25
From: Michael Naser
Subject: Working on Nested if Statement
Hi Everyone,
I was working on a currency formula, but it looks like my nested if statement does not work properly. The formula that I have now is
If([Reimburse Amount Override]>=0,[Reimburse Amount Override],
If([Category Requires # of 1-Way Trips Field],
If([Category - Multiplied by Mileage],
([# of 1-Way Trips] * [Category Rate]) * [Resource' Commuter Miles 1-way],
([# of 1-Way Trips] * [Category Rate])
),
[Mileage Cost]+[Cost]
))
The problem here is that Override works fine, but when I put "cost" and l leave "Reimburse Amount Override" blank , it does not calculate the cost any more!
------------------------------
Michael Naser
------------------------------