

May 2, 2014

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
1 Guest(s)
