Skip to Content
0

Save Formuala data

Apr 07 at 12:45 AM

53

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Chanti b Apr 10 at 12:45 AM
0

Hi ,

Please share any hint on this .

Thanks,

Chanti

Share
10 |10000 characters needed characters left characters exceeded
Chanti b Apr 11 at 02:18 AM
0

Hi ,

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

Please share any hint .

Thanks,

Chanti.

Share
10 |10000 characters needed characters left characters exceeded
Diego Ferrary
Apr 11 at 01:51 PM
0

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


Share
10 |10000 characters needed characters left characters exceeded