Calculated Field in a table - Not working? (1 Viewer)

thudson

Old Programmer
Local time
Today, 06:05
Joined
Apr 29, 2011
Messages
68
I am developing a database to track my items on eBay. I have 3 fields that calculate the total fees I pay to eBay - Insertion Fee + Final Value Fee + PayPal Fee. I created it using the Expression Builder as instructed when I created the new field, but after saving the table and checking the new field there are no values in the calculated field.
I have Office 365.
Why am I not getting the calculated values?:banghead:
 

Minty

AWF VIP
Local time
Today, 06:05
Joined
Jul 26, 2013
Messages
10,355
Do any of the fields involved in the calculation have null values?

Null + Almost Anything = Null

Make sure you have 0 as a default value in the source calulation fields
 

Mark_

Longboard on the internet
Local time
Yesterday, 23:05
Joined
Sep 12, 2017
Messages
2,111
there are no values in the calculated field.

Are you saving the calculated value in a table? If so, I'd not do that. You can always calculate these values for display purposes. Unless you have an auditory reason to keep them you should NOT be saving them.
 

thudson

Old Programmer
Local time
Today, 06:05
Joined
Apr 29, 2011
Messages
68
I found why it was not displaying a value!
I had not set the Result Type and the Decimal places.
Did not realise not doing that would result in displaying nothing!
 

Users who are viewing this thread

Top Bottom