none
IIF Syntax RRS feed

  • Question

  • Hi! I'm trying to add an IIF statement to do some additional calculations,

    Custom Field 1 is a Flag Field (Yes or No) to specify if there is an additional fee to pay for each task.

    Custom Field 2 is a Cost Field (Calculated) to specify the fee. The fee is equal to 5% of the Fixed Cost ([Cost]*0,05). 

    I want Custom Field 2 to calculate only when Custom Field 1 is equal to Yes. 

    I try to use the following formula but but I get a syntax error,

    IIf( [Arq. Fee]="Yes". [Cost]*0,05. 0 )  

    Any suggestions? Thanks!


    • Edited by isa7667 Tuesday, August 18, 2015 2:01 PM
    Tuesday, August 18, 2015 2:01 PM

Answers

All replies