Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.
Please check
LOAD "ProjectCPI",
IF("ProjectCPI" < 0.75, 'OverBudget',
IF("ProjectCPI" >= 0.75 and "ProjectCPI" <= 0.85 , 'Within Budget',
if("ProjectCPI" > 0.85 ,
'Under Budget' ))) as CostClassification
Or
LOAD "ProjectCPI",
IF("ProjectCPI" < 0.75, 'OverBudget',
IF("ProjectCPI" >= 0.75 and "ProjectCPI" <= 0.85 , 'Within Budget',
'Under Budget' )) as CostClassification
Or share some sample app
Hi Agrim,
LOAD "Project CPI",
IF("Project CPI" < 0.75, 'OverBudget', IF("Project CPI" <= 0.85, 'Within Budget','Under Budget' )) as CostClassification
LOAD "Project
CPI",
IF("Project CPI" <0.75, 'OverBudget',
IF("Project CPI" >0.85,'Under Budget','Within Budget')) as CostClassification
.
PFA....
.
could you share some sample output ...
What exactly you want
.
Hi Ajit ,
I already gave you that solution
LOAD "ProjectCPI",
IF("ProjectCPI" < 0.75, 'OverBudget',
IF("ProjectCPI" >= 0.75 and "ProjectCPI" <= 0.85 , 'Within Budget',
if("ProjectCPI" > 0.85 ,
'Under Budget' ))) as CostClassification
Please check above.