Using formula values in another formula

[Former Member]

Hello,

I´ve a little problem...

In a query that use some formulas, i have one formula(formula A) that gives me the '%CT', comulative value for a key figure. After that i create another formula that need to use the calculated value of the previous formula(formula A), but here appears the big problem... the value that appears isn´t the comulative value.

As i understand, the calculation is done at run-time and i can´t use this value... anyone can help me? This question isn´t very simple to explain..

many thanks ,

António Oliveira

[Former Member · Accepted solution]

Hello Antonio,

You use this calculated key figure in a new cal key figure.

if the %CT in the first cal key figure is calculated in result rows at runtime, it can still be used in the new cal key figure.

if u only want the result rows to be displayed, you can supress the sigle values in the properties-> calculate single value as ->supress result

Hope it helps..

thanks,

[Former Member · Accepted solution]

Thanks Aby,

But, i'm reading the manual, and as i understand, it sais that the local calculations, only changes the display of the changed values... the formula contains only the original value specified by the OLAP Processor.

It sais that for subsequent calculations, i need to have 2 structures in the query, and use Exception Cells...

I'm going to investigate this now...

Many thanks ,

António Oliveira

[Former Member · Accepted solution]

Hi Antonio,

No problem...The BEX will calculate with new values..

Just now , I checked it.

Take an ex and see:

ckf1= price*2

ckf2= ckf1*2

and check the results and confirm

cheers,

shylaja.

[Former Member · Accepted solution]

thanks shylaja,

but the formula i use is %CT for comulative values... and for that formula this doesn´t work... because the calculation is made only when the bex is contructing the result table.

thanks anyway,

António

[Former Member · Accepted solution]

hi Antonio,

Yes you are right. This is with regard to overall result.

So, you cannot use this for further calculation.

And thats the reason the functions %ct,%gt...are not visible in Calculated Kfs.

Shylaja.

[Former Member · Accepted solution]

Hi Antonio,

Did you ever find a solution to your problem? We have a similar requirement.

Thanks

Shai

[Former Member]

Could you please share the solution. We have the same issue.

[Former Member]

In that case, go for a calculated key figure than a formula.

[Former Member]

Thanks Venky,

but i don´t know if you understand very well my problem...

The value that i want to use, is calculated at runtime in a Bex Formula, so i can´t create a calculated key figure with values from this formula... i can only use key figures and variables.

Best Regards,

António Oliveira