cancel
Showing results for 
Search instead for 
Did you mean: 

Save Formuala data

Former Member
0 Kudos

Hi , I am new to AO and require help on save formula data to basic kef figure.

Ex : I have 3 KF's Price , Qty , Sales in columns

Sales = Price * Qty

I want include this formula in sales column ( Locked ) and while user input Qty and price then excel formula to show sales , then user will save data .

I am aware it is very easy in EPM but not able to find out solution in AO .

I understand from some posts , need to create fox code and call planning sequence while save the data . But I am looking to achive through AO .

Please advise some hint to achieve this .

Thanks,

Chanti.

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

Hi Chanti,

As you are using Analysis for Office you can use Advanced Calculation. as you can see by the following screen shots:

I believe that it can help you on this case.

Thanks,

Diego

Former Member
0 Kudos

Hi ,

I tried inverse formuala and sepsetdata() , unfortunately bith are not worked .

Please share any hint .

Thanks,

Chanti.

Former Member
0 Kudos

Hi ,

Please share any hint on this .

Thanks,

Chanti