How do you write the output of an Excel-calculation into PALO?

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • How do you write the output of an Excel-calculation into PALO?

    I'm working on my first 'real' project with PALO. So far I've been able to implement everything I wanted. But now I'm stuck with this:


    I have two cells (Y6;Y11) containing PALO.DATAC-fomulas.

    Now I need a third cell with this function: =(Y6+Y11)/2*Y$18%

    So far, no problem. But how do I write the output of the function back into the cube? Is there any easy way to achieve this or do I have to use VBA?

    Thank you for your help!
  • RE: How do you write the output of an Excel-calculation into PALO?

    Hi,
    first of all. Use PALO.DATA in (Y6;Y11) instead of PALO.DATAC in theis case to make sure that the following steps work.

    Let's say you got your calculation formula (Y6+Y11)/2*Y$18% in Y12.

    Now place a PALO.SETDATA formula in e.g. Y13 to write back Y12.
    This should work. Also you can wrap the SETDATA with IF.


    Hope that helps.

    Holger

    P.S.:Conditional SETDATAS with IF don't work in WSS2. PALO.SETDATA is alsways 'fired'. There are other solutions for this.