Log In
Register
Home
May 2, 2014
Offline
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
July 16, 2010
Offline
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
May 2, 2014
Offline
Yes, so OK, at least I know I am on track...:-) So what function should I use for that and what syntax? Thanks 🙂
July 16, 2010
Offline
Can you upload a file with your data so I can see it in context?
May 2, 2014
Offline
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 🙂
1 Guest(s)
