Straight Table Expression Sum as Variable

[#1]

Hi Folks,

I cretaed the Straight Table. I need to use the expression sum in the Straight table as variable. How can I do that?

Can I use the expression in the Startight Table as the column out side of the table chart?

Thanks & Regards,

Siri

[danielact]

You can't create expressions in a table box. Use a straight table instead.

[#3]

Hi thanks for your reply. Sorry I am asking wrongly.

My question regarding Straight table only.

[oscar_ortiz]

You can create a variable in your document and use that as part of the expression:  For example create a variable vExpression with the definition of =Sum(Sales) then use the $(vExpression) in your chart's expression.Good luck

[#5]

Hi Ortiz, Thanks for your reply.

I need the use the total sum of the expression in the straight table as variable. Please find the below Image.

Please help me in this.

Thanks & Regards,

Siri

[jonathandienst]

Hi

Define a variable (lets call it vTotalRAM):

In your script:

Set vTotalRAM = Sum(Aggr(Sum(RAM), QVWName));

After reloading you can use the expression $(vTotalRam) to get the value which should be the same as the table total.

Regards

Jonathan

[#7]

Hi Jonathan, Thanks for Your Reply.

The RAM is not a column. In the above straight table, QVW NAME, Document Size and Concurrent Users are the columns. Others Expression Values.

RAM Initial = [SIZE(KB)]*vFileSizeMultiplier

RAM USER=([SIZE(KB)]*vFileSizeMultiplier*vUserRAMratio)/100

RAM=([RAM USER]*[Concurrent Users])+[RAM Initial]

So I need to use the total sum value as vaeiable and RAM as the List box.

Please provide your suggestions.

Thanks & Regards,

Siri

[jonathandienst]

Hi

Then use this instead:

Sum(Aggr(Sum(([RAM USER] * [Concurrent Users]) + [RAM Initial]), QVWName))

Regards

Jonathan

[#9]

This helped me a lot. Thank you very much.