Index

Related topics:

IIf

Tutorial Videos

Tutorial videos are available here.

Knowledge Base

Visit our User Forum for discussions & solutions

IIf – XpressDox

This function is a kind of short cut to writing «If()»«Else()»  … «End()» in certain circumstances.

 

Using If.. Else.. End:

Suppose you want to write something like

The amount of VAT applicable is ….

Where the …. above is either zero, if no VAT is applicable, or is Amount * VatPercentage div 100.

Using the If command that would be:

The amount of VAT applicable is «If((VatApplicable = 'Yes')»«FormatAmount(Amount * VatPercentage div 100)»«Else()»0.00«End()».

 

Using IIf:

You could combine those all into one fillpoint like this:

The amount of VAT applicable is «IIf((VatApplicable = 'Yes'),FormatAmount(Amount * VatPercentage div 100),'0.00')».

 

This function, the Inline If, gets its name from the Basic language function which operates in a similar fashion.

 

Related articles:

Conditional processing

Learn more about conditional logic here.