Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I am looking for equation that will do following.
Fields:
ServicePurchaseDate
hours purchase
hours worked
if ServicePurchasedate is less then 12 months (from current selection) (or from today) then hours purchase - hours worked. if not then show 0. If hours worked acceds hours purchase then show negative number
Maybe something like
=if([ServicePurchaseDate] > addmonths( today() ,-12), [hours purchases] - [hours worked],0)
Hi,
just to be sure to well understand your question, could you please give us an example of what you're looking for?
Thanks
Giampiero
if(year2date(ServicePurchaseDate),hours purchase-hours worked,0)
if ServicePurchaseDate is less then 12 months from current date, then hours purchase - hours worked.
thanks
Maybe something like
=if([ServicePurchaseDate] > addmonths( today() ,-12), [hours purchases] - [hours worked],0)