I am hoping that someone can help with my question here. Basically I have a test that calculates employees that have >20% cash to expense ratio from an employee table. THis table also has a date. Loading all the data works fine for the test but when selecting a specific date ( for example, Aug 2013) it does not update. It still is in reference to the entire data population. How do I make sure that the result updates for only the specified date selected?
,IF(Sum_Cash_Emp/Sum_All_Emp >= .2 ,'Yes','No')