1 of 1 people found this helpful
I'm not sure if this will help, but what if you combined the begin year and begin month fields into a calculation and end month/year into a separate calculation, then use the two calculations in your final calculation?
Are you able to post the workbook (as a twbx file)?
I'll try your idea of combining the calculated fields and then using the combined fields in the final calculation. There is always more than one way to skin a cat. Although, I'm still wondering if there is anyway to get the "behind the scenes" queries improved. In the situation I described, using four calculated fields creates a select query with 10 nested CASE WHEN statements.