Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.
Your might be wrong.
Try like:
IF("Project CPI"<0.9, 'Under Budget', IF("Project CPI" <=1, 'Within Budget', 'Over Budget' ))) as CostClassification
I might go with something like:
IF("Project CPI"<0.9, ' OverBudget',
IF("Project CPI">=0.9 and "Project CPI"<=1.0, 'Within Budget',
IF("Project CPI">0.9, 'Under Budget'
))) as CostClassification
FROM [lib://vvv/vvvv.xlsx]
(ooxml, embedded labels, table is Projects);
Put both conditions in the Withing Budget part of the statement with an 'and' Boolean operator.
Your might be wrong.
Try like:
IF("Project CPI"<0.9, 'Under Budget', IF("Project CPI" <=1, 'Within Budget', 'Over Budget' ))) as CostClassification
.
Hi Agrim,
add
Where [Project CPI] >= 0.9 and [Project CPI] <= 1;
Regards,
Antonio
Have a look at the attachment.