Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • Last Modified:

Calculated field in a table

I'm trying to include a calculated field in table design.  The fields I'm using for the calculation are:

[LeadFromEd]+[AgentLead]+[CommissionSoldListing]

But I'm also trying to account for empty values by using:

Nz([LeadFromEd],0)+Nz([AgentLead],0)+Nz([CommissionSoldListing],0)

But it won't let me.  I get an error that reads,

The expression Nz([LeadFromEd],0)+Nz([AgentLead],0)+Nz([CommissionSoldListing],0) cannot be used in a calculated column.

????

--Steve
0
SteveL13
Asked:
SteveL13
1 Solution
 
Rey Obrero (Capricorn1)Commented:
this is not a good  idea.

you can always derived a calculated column using a query.
0
 
Jerry MillerCommented:
I agree with capricorn1 that it is not a good idea. If you need the values, use a query to determine your derived columns. It violates normalization rules.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now