Dear visitor, welcome to Palo Community Forum.
If this is your first visit here, please read the Help. It explains in detail how this page works.
To use all features of this page, you should consider registering.
Please use the registration form, to register here or read more information about the registration process.
If you are already registered, please login here.
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.
Sorry for the delayed reply...
Thank you VERY much for your help, it's all working now
