1 Reply Latest reply: Feb 9, 2015 4:44 AM by Gysbert Wassenaar RSS

    Update result for selected Date

      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!