How do I multiply the results of a column from one analysis with a result of a column from another a

Question

Hello

For technical reasons, there are two columns I can't have in the same analysis.  However, I need create a column in another analysis that multiplies the two values together.

I have gone to the 'Edit Column Formula' diaglog but I cannot figure out a way to pick the results of the other analysis.  The column itself in the other analysis is already a calculated item so I can't just pick it from the list of available columns.

Is anyone able to help or advise if this is possible?

Many thanks

Michael.

Sherry George · Answer

Since I do not know exactly what your model and report is, I'm limited in my answer. What I'm suggesting is, in your second analysis which has colB, colC, colD create a column and use 'Evaluate' function in the formula to call the database function that you have created which will return the value of colA.

3423849 · Answer

Hi Sherry

This was something I had thought of but I could not figure out how to do it.  It would be good if I could give the value of Column A a name or reference that I can then use in the column forumla of Column F in my second analysis, so it ends up as (Column F*TheResultOfColumnA).

Best wishes

Sherry George · Answer

One possible way to achieve this will be calling a database function (with passing the required params) to get colA value in the analysis containing colB.