How to track when project spending has slowed for 2 months in a row?

[Rcaaa]

Hello,

I'm wanting to create an indicator that shows me when a project has overspent for multiple months or under spent by multiple months. I want to do this for over 50 projects.

I have monthly spending by project. I'm considering using outlier formulas to show me when spending is abnormal.

Main Question: How would I get the outlier (true/ false) to be based on only the information for each project number.

Project Number	Month	Total Cost	Outlier
XX	1	$20,000	False
XX	2	$30,000	False
ZZ	1	$30,000	False
ZZ	2	$40,000	False

If anyone has seen something similar to what I am describing, I would appreciate if you could point me in the right direction.

Lower range limit = Q1 – (1.5* IQR)
Higher range limit = Q3 + (1.5*IQR)

Thanks,

Rcaaa

 

[StephenCrump]

Perhaps you can post some examples illustrating when the Outlier check should be TRUE.

At the moment, many things are not clear, including:
- Why the lower range limit is based only on Q1
- Why the upper range limit is based only on Q3
- How you are calculating IQR
- How the Quarter numbers and month numbers are related?