Forum Discussion

Drikus's avatar
Drikus
New Member
2 years ago

LASTNONBLANK issue

I have a listing of sales invoices which I need to translate the value to USD using the rate on the date of the invoice.  I have set up an FX table that automatically imports the FX rates from the E...
Drikus's avatar
Drikus
New Member
2 years ago

some_bih  Thanks so much. I'll definitely work through that article. That might just be a better way than I'm doing at the moment. 

Yes the dates was a typo 🙂

I'm still quite curious why LASTNONBLANK is not returning the correct value. 

For 2021 its working well up until 31 March 2021 and for 2022 its working well up until 30 September 2022. 
Its strange to see a formula performing as expected for a certain portion of the year, but not for the other portion of the year

  • some_bih's avatar
    some_bih
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi Drikus 

    LASTNONBLANK perform CONTEXT Transition so it is hard to understand what is wrong looking just simple measure definitions.