I want to calculate a sum of several (6) fields using calculated value field. Almost always there will be fields with NULL value among these 6. How do I create a formula that 1) scan all 6 fields, 2) select only fields with value (or replace NULL value with 0) and 3) sum these fields.

You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

## Question

## Caspiosa

HI!

I want to calculate a sum of several (6) fields using calculated value field. Almost

alwaysthere will be fields with NULL value among these 6. How do I create a formula that 1) scan all 6 fields, 2) select only fields with value (or replace NULL value with 0) and 3) sum these fields.Thanks!

## Link to comment

## Share on other sites

## 3 answers to this question

## Recommended Posts

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Note:Your post will require moderator approval before it will be visible.