4 followers Follow

Data types error message for new custom field

Attempting to create a new custom field (Percentage) and I’m running into an error message (Data types Duration and Numeric not compatible for '-' operation) that I’ve not been able to resolve.  The new custom field is a calculation based on two other existing custom fields, both of the existing fields are also calculations (we’ll call them FieldA and FieldB). 

FieldA is a Numeric/Formula field based on the sum of other duration fields (hours).  Field B is a Duration/Formula field based on projecting out project hours (Actual Effort / % Complete).

The calculation I’m attempting is (FieldA-FieldB)/Field B.

Is there a formula I can use to resolve the error message or an easy way to change the data type of the existing custom FieldA & FieldB?

Kevin Fulmer Answered

Please sign in to leave a comment.



Hi Kevin,


That's a great question! Basically you're trying to perform a subtraction on two different field types. In your case is numeric and duration. So in order to make it successful you need to confer FieldB to numeric value (covering FieldA doesn't make sense since the final output is numeric).

The formula should be something like this (FieldA-FieldB/Hours(1))/FieldB/Hours(1)

Please let me now if that worked out for you!




Tamir Avital 0 votes
Comment actions Permalink

Especially if you are looking at finding a freelancer or perhaps a organization you might be not really acquainted with for several a long time involving audio transcription, the subsequent information may possibly prove very helpful. Keep reading to find out the actual wonderful means for the painless on the internet transcription purchase. The most apparent strategy to presenting a great on the web transcription expertise is beginning with good high quality audio tracks. affordable transcription services I take care of almost all comments from customers immediately, in order that I noticed the impact we've got on the people that issue nearly all. A number of our proudest times are generally reading people comments and hearing things like I became impressed with the level of responsive consumer service I right away received or It really is a real enjoyment that can assist you. You've made our career far more easy. Not to mention, the very best go with coming from all, any referral. Transcription Metropolis, we like to offer you our own customers the most effective value for his or her money using the regular monthly transcription offers. Transcription City’s special offers site regarding affordable transcription services. Having a free trial offer transcript, you can look at before you purchase, to ensure that you acquire precisely what you are searching for. At Transcription Metropolis, we all take great pride in exactness, formatting and overall good quality for all of our own transcripts. Hour or so trans ended up being an ideal fit. I acquired our transcripts in advance of when these were assured and the transcription ended up being extremely exact. They had been definitely great to utilize. His or her services are not only found expert, however they are very ready provide suggestions to be able to along with help people, similar to personally, who'd in no way necessary transcription services just before. I'm able to, and do, recommend Hr trans 100%.

Courtney -2 votes
Comment actions Permalink