I am trying to backlog some data and only have the value total. I am trying to write an equation that will allow me to add a total revenue to the revenue I have accumulated by area. The equation I have for that is this:
Sum({$<Status_Dash={'Completed'}, Year = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"}>} (Ave_Cost_Dash * Processed_Dash))
I simply want to add revenue from Jan, Feb, Mar, Apr, May from this year to this equation.
So how can I add
if current year is equal to 2017
then add total_revenue from jan, feb, mar, apr, may in 2017.
I am trying to add this so I won't have to go back at the beginning of next year and take out those from all my expressions.
