Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Alright, I am trying to calculate processed for the month. This formula works, but now since it is the 1st, we have no revenue. In my table my processed tab actually is processed prior day. Is there any way to make this formula not include the first workday in the month.
Sum({$<Program_Dash={'Mechanical Inspection'}, Status_Dash={'Completed'}, Date_Dash={"$(=FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00')-1,1,$(vHolidays)))"}>} (Ave_Cost_Dash * Processed_Dash))
Create a Master Calendar that span all days in your fact Table ...
Create a Flag of all dates at the MonthStart ..
if (Date = MonthStart(Date),1,0) as excludeFirstMonth
Then add in your set Analysis
excludeFirstMonth = {0}
Here is a sample. In the database, I put a dummy date for tomorrow the 2nd to see if that would work. If needed I can take it out and reattach.
So what exactly are you looking to do here? You have 8/2/2017 data and you would want to see the Revenue for which date?