Why do calculated fields not work if one factor has a 0 value?

(0) Share

Report

Posted on by Cyclefitness

I have a calculated field that does this:

A = B - (C+D)

All of the fields being used are USD currency. If C or D have a $0.00 balance, the calculated field shows nothing. Once I put > 0.00 in the field, then the calculation works. Why is this?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Cyclefitness on at

Like (0)

Report

Well, one issue I discovered is my Field Security Profiles seem to ignore that I'm an Administrator. Unless a member of the Team specified in the Field Security Profile or a specified User, the calculated fields behave crazy. I added myself and now it updates, but the totals are still really weird.

Was this reply helpful? Yes No
Cyclefitness on at

Like (0)

Report

Here's what I have:

AVAILABLE = Start $ - (Payments $ + Encumbered $).

I'm figuring that result should be $1,311. It's adding the Total Payment negative amount rather than subtracting. This is some crazy math thing, I'm sure. ;-)

Was this reply helpful? Yes No
Cyclefitness on at

Like (0)

Report

But then if you look at this group of numbers -- on the same form -- this AVAILABLE amt is correct. It's processing the negative correctly. AVAILABLE = (Payments $ + Encumbered $)

:

Same formula as in the previous post:

It's late and I'm tired, but I don't think I'm really that bad at math.

Was this reply helpful? Yes No
Cyclefitness on at

Like (0)

Report

And then this screenshot is another record on the same entity. WHAT GIVES here???

Was this reply helpful? Yes No
Suggested answer

Teddyable 155 on at

Like (0)

Report

Calculated field can be very annoying, if you miss a minor detail.

but sometimes it pays to go back to basics, have a look at this links, it helped me when i had a similar headache

msdn.microsoft.com/.../dn817863.aspx

www.preact.co.uk/.../working-with-calculated-fields-in-microsoft-dynamics-crm

www.youtube.com/watch

hope it sort of helps

Was this reply helpful? Yes No
Cyclefitness on at

Like (0)

Report

Thanks for the info, Teddy. I've read through everything and don't find anything that explains the inconsistent behavior.

Was this reply helpful? Yes No
Cyclefitness on at

Like (0)

Report

Hi Guido!

I'm unfamiliar with the | in your syntax. Is that something to literally add to the equation?

Oh, and if I only knew JS to be able to do that. ;-) And if JS was implemented, then the values would only update on form load, correct? Doesn't a calculated field also update if a report is run against it?

Was this reply helpful? Yes No
Cyclefitness on at

Like (0)

Report

Guido ... also in the second example I just don't understand why there is no value in AVAILABLE? It, too, should be displaying a negative number.

Was this reply helpful? Yes No