Project Online - PWA RAG Indicator
Hi all, in need of some assistance
I am currently using project online linked with PowerBi and am trying to do a schedule RAG against set bassline for each project.
The formula im using is nearly there and working, however some tasks are showing green indicators with the text beside stating Amber or red.
Formula using is below
IIf([Finish] - [Baseline Finish] > 30, "Red", IIf([Finish] - [Baseline Finish] > 15, "Amber", "Green"))
I'm sure its a quick fix but i cant find it
Thanks
|