Hi,
I have a column as "amount" requested from my customer to save all the amounts he predicted to make in 2021/9.
But no matter what amount he filled in, this prediction will be ended up in 2021/8/15.
And he can make a comparison with the truth of 2021/9.
So I need to keep the prediction in another column like "Prediction_2021/9" that we can make the checking procedure.
In Dataverse, I made a calculated column that
"Prediction_2021/9" would be set as the copy of "amount"
if the modified date before 2021/8/15,
but the problem is
if "amount" was modified AFTER 2021/8/15, whatever the amount saved in "Prediction_2021/9" would be CLEARED.
I did nothing in Else part that I have no idea how to prevent the "refreshing".
What should I do to keep the previous amount there without clearing?
Thanks.
