8 Replies Latest reply: Apr 28, 2016 12:24 PM by Francisco Sotomayor Huerta

Straight Table Expression Sum as Variable

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

• Table Chart Expression Sum as Variable

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

• Table Chart Expression Sum as Variable

My question regarding Straight table only.

• Table Chart Expression Sum as Variable

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

• Table Chart Expression Sum as Variable

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

Thanks & Regards,

Siri

• Re: Table Chart Expression Sum as Variable

Hi

Define a variable (lets call it vTotalRAM):

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

• Table Chart Expression Sum as Variable

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.

Thanks & Regards,

Siri

• Re: Table Chart Expression Sum as Variable

Hi

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

Regards

Jonathan

• Re: Straight Table Expression Sum as Variable

This helped me a lot. Thank you very much.