Percent Calc How to ... ?

[raul]

Hi Alex, i have this colunms in Excel:

custno, cost , benefit , %benperc

1-------1000--------500--------50% <- =(benefit/cost*100)
2-------3000-------1800-------60% "
Tot-----4000-------2300-------57% <- =(benefit.tot/cost.tot*100)

In cube using measures...
- custno, cost , benefit , %benperc

-------1-------1000-------500-------50%
-------2-------3000------1800-------60%
________________________________
------tot------4000------2300------110 (summa, summa, summa) or ...
-------------- 4000------2300-------55 (summa, summa, average)
or ... any measure

How can I get the correct percent (2300/4000*100) => (57%) ??
I need always to divide totals as result
thanks

[AlexZencovich]

Add calc. measure like "% of benefit" with formula

begin
Result = "benefit"[VALUE]/"cost"[VALUE];
end

[raul]

Thanks,
Can I add Programmaticaly a calc meassure with formula or import the formula from the formula cell in excel sheet?

[AlexZencovich]

1. Yes, you can do it with
PCX.MapAddCalculatedMeasure(const Name: WideString; const Formula: WideString)

2. I do not sure if Excel sheet formulas are compatible with built-in langauge