I have a troulble setting a calc script: I should calculate the value
of revenue=quantity(2004)/((revenue(2003)/quantyty(2003))
Where revenue and quantity are account (dimension measures)
and 2003 2004 are children of the dimension scenario.
I made a new scenario, called MIX, and a calc like this

DATACOPY "Quantity"->"2004" TO "Quantity"->"MIX";
FIX(MIX)
"Revenue" = "Quantity" * (***);
ENDFIX

I don't know how to find the value (revenue(2003)/quantyty(2003) under
the FIX(MIX).
Anyone can help me?

Thnaks

Why don't you just do what you indicated in your pseudo-code:

FIX (MIX)
"Revenue" = "Quantity"->"2004" *
("Revenue"->"2003" / "Quantity"->"2003");
ENDFIX

Regards,
Jade


Gus79 wrote: