Question:
hello,
I've some trouble with calculated ratios on different units.
I'll try to explain but I apologize for my poor english from a little frenchy
I've a formula like : A / B * C with A & C can have different unit on each material.
with a drilldown view the Result was false but using the priority for totalisation It's now OK.
But without the drilldown view the ratio is calculated with the formula on some false ratios (like A & C) due to different units addition.
Is it possible to make the ratio calculated like a result (in addition from individual values) or will I be obliged to put this ratio directly in the cube ?
I don't know if it's really clear but I hope one of you could help me.
thx
--
fab.
Answer:
when I'm talking about ratios I want to say Key Figures sorry...
Answer:
I guess A and C do have the same unit each time for any product ?
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
I guess A and C do have the same unit each time for any product ?
yes.
but we're now passing the key figures into the cube that seems better and we'll now be sure that the key figures will be calculated before the aggregation.