Calculate ONLY when field has a value

[corey]

In the attached file there is an example of what i trying to achieve.

I am sure it has a simple answer too.

But to date cannot solve it.

I have a series of fields (non-rep) that display a running total.

Each field has an adjacent field that i want to display a break down of each seperate length of the total length.

Each adjacent field i have set it to a simple calc to subtract the previous field result from the current field result, thus giving a break up of that separate length.

The problem arises when i don't need all the fields and some of the remaining fields are left empty, the adjacent field will display the running total as a MINUS (eg -135)

I has selected the storage ioption to ONLY calc if fields are not empty, but i still get the last adjacent field/s displaying a MINUS result, instead of NO result at all.

Can anyone assist me with this, i am sure it is simple to solve, somehow

corey....

Test.zip

[transpower]

Use the Case function.

[MoonShadow]

I've only had time to take a quick look, but try playing with something like this:

If(size f, size f - size e, "")

This will leave size f and size f actual blank.

But if you need the running total to continue for more fields, you might wish to carry size e actual forward as this:

If(not size f, size e actual, size f - size e)

[-Queue-]

Case( size b, size b - size a )

or

Case( not IsEmpty(size , size b - size a )

if you still want to get an answer when size b = 0.

[corey]

Thanks MoonShadow.

Case( size b, size b - size a )

was perfect for what i needed.

thanks all for your replies

corey....