Using variable in a Table Box

[anuradhaa]

Hi,

I have define a variable name "cost" in document properties,

my expression is

"=round((140*Time)/Quantity,2)"

Now i want to show that variable in a table box.

Please tell me how to do that.

I have attached my qvw here.

Thanks

[jagan]

Hi,

Use Aggregate function like sum, because you have multiple values, please check below expression, your expression works only when you select any ID.

=round(Sum((140*Time)/Quantity),2)

Hope this helps you.

Regards,

Jagan.

[Gysbert_Wassenaar · Accepted solution]

You can't use variables or expressions in a table box. A table box can only show fields. You'll have to use a straight table object. Create a new Chart object, choose Straight Table as chart type, add your dimensions and finally add your expression.

[anuradhaa]

Thanks All