Skip to Content
avatar image
Former Member

Save Formuala data

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 10 at 12:45 AM

    Hi ,

    Please share any hint on this .

    Thanks,

    Chanti

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11 at 02:18 AM

    Hi ,

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

    Please share any hint .

    Thanks,

    Chanti.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11 at 01:51 PM

    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

    Add comment
    10|10000 characters needed characters exceeded