I've created a custom column as follows..
if([Deferred_percentages.Deferred]<>0 or [Deferred_percentages.Deferred]<>1) These are both formatted as decimal numbers
and ParameterEarnedDate >=[StartDate] First one is a parameter query (formatted as date), [Start Date] is formatted as date
then ([Amount]*(1-[Deferred_percentages.Deferred])+(ParameterEarnedDate-[StartDate])*[Amount_earned_per_day]) else 0
([Amount] and [Amount_earned_per_day])= Decimal number
This is the error message I am getting.. do I need to change data types? What am I missing?
Expression.Error: We cannot apply operator + to types Number and Duration.
Details:
Operator=+
Left=0
Right=27.17:26:37.6642335
Hi Anne,
I think this part of the formula (ParameterEarnedDate-[StartDate]) is the problem because it's a date/duration and you're trying to add it to a number. So yes, you need to convert the data type for that to a number.
Mynda
Yes, so OK, at least I know I am on track...:-) So what function should I use for that and what syntax? Thanks 🙂
Can you upload a file with your data so I can see it in context?
I tried answering in this box but it wouldn't let me so I am attaching a file with the data and a file with the various explanations..thanks again 🙂
Hi Anne,
The Excel file appears to have been removed and the Word document is empty. Can you please try again?
Mynda
GRRR.. I actually found another way around it after this but thanks for your help anyway 🙂