Question:
When I use a condition (e.g. 'Actuals'>0), then my % variance result show up as number, not a percentage.
e.g. ('Actuals'>0)* 'Actuals' % 'Budget
with Actuals = 120 and Budget = 100, gives the result 20, not 20%
Shouldn't % variance work with conditions?
//hopp
Answer:
And, if you try to put this Formula instead ?
(('Actuals'>0) * 'Actuals') % 'Budget'
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Then SAP takes away the outer brackets when I save and pretty much ignores the condition.
After saving the formula looks like this:
('Actuals'>0) * 'Actuals' % 'Budget'
Cheers,
hopp