AnsweredAssumed Answered

need help to create nsql query

Question asked by rocker on Oct 22, 2012
Latest reply on Nov 22, 2012 by Owen_R
Hi,

I need to create a portlet to display the cost health for the project.

cost health is calculated as ----->

Cost health of the Program/Project
If the actuals are as per the planned cost then it is Green, if the variance is 5% from planned cost then it is Yellow and if it is 10% from planned cost then its Red

do i need to create a seperate view for this or an nsql query is enough ?

Outcomes