where 'current' value of most recent date (31 jan) of maker+model+class = previous 'current' of same maker+model+class , then TRUE where 'current' value of most recent date (31 jan) of maker+model+class <> previous 'current' of same maker+model+class , then FALSE if FALSE, then compare against previous 'new' value.. if they are the same then TRUE, if not, then FALSE

thanks for your reply, see attached.

Please see attached. I have been trying to use FIXED and other calculations but not quite working. I am trying to show the following based on the latest date (31/1/2025):

where 'current' value of most recent date (31 jan) of maker+model+class = previous 'current' of same maker+model+class , then TRUE
where 'current' value of most recent date (31 jan) of maker+model+class <> previous 'current' of same maker+model+class , then FALSE
if FALSE, then compare against previous 'new' value.. if they are the same then TRUE, if not, then FALSE

3 answers

Add a comment

0/9000