Values don't change after a date.

[D19PAL]

Hi,

You know how in excel you can copy a cell with a value calculated by a formula and then paste it as a value, can we do that in QS?

So current date it looks at the figures calculated with the expressions or in the script.  But our historic data needs to be locked down, what the calculated value was at the end of yesterday.  It can't change today.

Both have to be in the same table or concatenated or joined or however it can be done.  Can it be done?

Regards

[Mark_Little]

Yes it can be done, but it would have to be something that is calculated in script and stored out to a data file, for prior values.  

Then you can have an if before this data take the data File value else do the set analysis.

Would need more details to help with more detail. 

[D19PAL]

Thanks.

What details do you need?