how to create variance based on new updated snapshot date

[#1]

Hi all,

i have a straight table with projectid & name i want see variance amount based on the latest snapshot date

can you plese help to get expression for variance.

regards,

venkat

8860844721