Get Lastoccurrence data

Hi,

 

Please help how can I get the last value in my module. I tried to use a rank function but can't reverse the ranking to ascending because the source value are the same amount. 

 

tompatrickting_1-1596554374184.png

 

 

Thanks in advance for the help.

Tom

 

Best Answer

  • Misbah
    Answer ✓

    @tompatrick.ting 

     

    If you don't want to tweak the formula in your current line item create another line item. See if below helps

    Misbah_0-1596557038027.png

    Misbah_1-1596557115975.png

     

Answers