Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How get the last value on a given date

Hi all.  I have  table:  that false.  Would like to see the remainder from 12885,82625 as of 04.12.2019 More samples as I want to see: I try next queries, but nothing correct work...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous 

can't calculate the lastdate()

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous 

What do you mean you can't? Is there any error message?

You use calcuate() to call out the [Remdoc] column value, and filter to the lastdate of the given date.

 

Paul 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous 

    Yes, error. Did as in your exemple.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous  can you help me?