locked
Return value with max date RRS feed

  • Question

  • User395515100 posted

    Hello All,

    I have a simple report below.  it is grouped by Staff Name.  For the rate at the group header, I want to return the value with the most recent effective date (max date).  For example, Dawn's rate should be 120.00, Carol's rate should be 100.00, and Ashley's rate should be 150.00.

    Thank you in advance.

    KJN

    Employee Info
    Name Initial Rate Effective
    Dawn DMA   2/1/2014
        120.00 2/1/2014
        100.00 6/1/2013
    Carol CCA   2/1/2014
        100.00 2/1/2014
    Ashley AKB   3/1/2015
        150.00 3/1/2015
        165.00 9/1/2014
        120.00 2/1/2014
    Friday, April 17, 2015 1:50 PM

Answers

All replies