Update result for selected Date

[#1]

Hello Everyone,

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?

Test:

MAPPING LOAD
Concur_Emp_ID
,IF(Sum_Cash_Emp/Sum_All_Emp >= .2 ,'Yes','No')
RESIDENT TE_Date;

Thank You!

[Gysbert_Wassenaar]

I'm not sure I understand your question. Are you perhaps looking for a where clause?

MAPPING LOAD
Concur_Emp_ID
,IF(Sum_Cash_Emp/Sum_All_Emp >= .2 ,'Yes','No')
RESIDENT TE_Date

WHERE MyDate = ..... ;