my problem here is that it isn't enough to check if previousvalue - current value > 50,000 because we are using opp products
and then when ever owner add product it changes the previous value amount but it isn't the final check, he might add 10 products.

any idea?

if flag changed from Red to Yellow/ from Yellow to Green/ from Red to Green, progress is 'better'
if flag changed from Yello to Red/ from Green to Yellow / from Green to Red, progress is 'worst'
if no change from last week, progress is 'no change'

Thanks

if flag changed from Red to Yellow/ from Yellow to Green/ from Red to Green, progress is 'better'
if flag changed from Yello to Red/ from Green to Yellow / from Green to Red, progress is 'worst'
if no change from last week, progress is 'no change'

Thanks

my problem here is that it isn't enough to check if previousvalue - current value > 50,000 because we are using opp products
and then when ever owner add product it changes the previous value amount but it isn't the final check, he might add 10 products.

any idea?