Help with IIf

[Guest]

Hi

Need help on creating a IIf based on the criteria below

If "Option1" (boolean) is yes
let "Calculatedamount" = "Amount" * "? %"
If "Option1" (boolean) is no
let "Calculatedamount" = "Amount"

That is all

Thank you in advance.

Mattias

 

[Guest]

Mathias,

IIf(option1, [true condition],[false condition])

given that Option1 is boolean

Jeff Shanker

 

[Guest]

Hi Jeff

please can you help me with all the syntax for calculating the
"Calculatedamount"


Mattias

Mathias,

IIf(option1, [true condition],[false condition])

given that Option1 is boolean

Jeff Shanker

Hi

Need help on creating a IIf based on the criteria below

If "Option1" (boolean) is yes
let "Calculatedamount" = "Amount" * "? %"
If "Option1" (boolean) is no
let "Calculatedamount" = "Amount"

That is all

Thank you in advance.

Mattias

 

[Guest]

Mattias,

Are you looking for something like:
CalculatedAmount: IIf(option1, [Amount] * ??, [Amount])

Although I'm not too sure what you are using at the end of your calculation.

Jeff

Hi Jeff

please can you help me with all the syntax for calculating the
"Calculatedamount"


Mattias

Mathias,

IIf(option1, [true condition],[false condition])

given that Option1 is boolean

Jeff Shanker

Hi

Need help on creating a IIf based on the criteria below

If "Option1" (boolean) is yes
let "Calculatedamount" = "Amount" * "? %"
If "Option1" (boolean) is no
let "Calculatedamount" = "Amount"

That is all

Thank you in advance.

Mattias

 

[Guest]

Hi again Jeff

Amount is a currency field, lets say it has the value 100
If Option1 is true I want to calculate a value (addon). If the % field has
the value 50%: 100 * 50%, the result of this calculation I want to add to
Amount fields value 100.
If Option1 is false I want the whole calculation to end with the value in
Amount: 100

Sorry I missed the addon part before.

Mattias

Mattias,

Are you looking for something like:
CalculatedAmount: IIf(option1, [Amount] * ??, [Amount])

Although I'm not too sure what you are using at the end of your calculation.

Jeff

Hi Jeff

please can you help me with all the syntax for calculating the
"Calculatedamount"


Mattias

Mathias,

IIf(option1, [true condition],[false condition])

given that Option1 is boolean

Jeff Shanker

:

Hi

Need help on creating a IIf based on the criteria below

If "Option1" (boolean) is yes
let "Calculatedamount" = "Amount" * "? %"
If "Option1" (boolean) is no
let "Calculatedamount" = "Amount"

That is all

Thank you in advance.

Mattias

 

[Guest]

Mattias:

If Amount and % are 2 fields in the same record, then CalculatedField:
IIF(Option1, ([Amount]*[% field]) + [Amount], [Amount]. Otherwise, I'm not
sure what you are trying to do.

Jeff

Hi again Jeff

Amount is a currency field, lets say it has the value 100
If Option1 is true I want to calculate a value (addon). If the % field has
the value 50%: 100 * 50%, the result of this calculation I want to add to
Amount fields value 100.
If Option1 is false I want the whole calculation to end with the value in
Amount: 100

Sorry I missed the addon part before.

Mattias

Mattias,

Are you looking for something like:
CalculatedAmount: IIf(option1, [Amount] * ??, [Amount])

Although I'm not too sure what you are using at the end of your calculation.

Jeff

Hi Jeff

please can you help me with all the syntax for calculating the
"Calculatedamount"


Mattias
:

Mathias,

IIf(option1, [true condition],[false condition])

given that Option1 is boolean

Jeff Shanker

:

Hi

Need help on creating a IIf based on the criteria below

If "Option1" (boolean) is yes
let "Calculatedamount" = "Amount" * "? %"
If "Option1" (boolean) is no
let "Calculatedamount" = "Amount"

That is all

Thank you in advance.

Mattias