Exponenciel - Efficient and affordable Sage ACT! add-ons

You are here: home > support > online help > automatic field calculations for act! 2020 > table of content

Online help
Automatic Field Calculations

PREVIOUS TOPIC
Yes/No Fields

NEXT TOPIC
Blanking a field out

Using a function inside another function

It is possible to use a function in one or more arguments of another function. Make sure you use parenthesis properly though as they are critical to avoid errors.

Here is an example: if FieldA is not blank then write the average of 3 fields (B,C and D) to the target field. Otherwise write "n.a.":

In this example, the avg function is "nested" inside the If statement. You can "nest" as many functions as you want. This capacity of Automatic Field Calculations is key and can lead to pretty complex but powerful calculations.

PREVIOUS TOPIC
Yes/No Fields

NEXT TOPIC
Blanking a field out

Back to the Table of Content

   

Across this Web site, ACT! and ACT! Premium, Sage ACT! Pro and Sage ACT! Premium are referred to as ACT! or Sage ACT!.

home | products | support | order now | resellers | contact us | meet now
Design by Exponenciel

Exponenciel has been a leading developer of Sage ACT! add-ons, Sage ACT! addons, Sage ACT! plug-ins, Sage ACT! plugins since 2001.
ACT!, ACT! for Workgroup, ACT! for Web, Sage ACT! Pro and Sage ACT! Premium are registered trademarks of Sage Corporation.