Forum Discussion
JoeKat07
9 years agoFrequent Visitor
Over threshold by quarter
i'm trying to find if a client goes over a threshold of hours by quarter. Here is the table i'm working with. I'm completely lost on this one
JoeKat07
9 years agoFrequent Visitor
Close, but if you look carefully each of the project id's have a different threshold. I need it to be calculated for each individual threshold
MarkS
Resolver IV
9 years agoHi,
The formula calculates the threshold of each Project ID, year, and Quarter when put in a table visual with these values.