Grab value from a table

[osni_campos]

Good Morning

It is possible to place a text object value of a sum of a cell or expression of a particular dynamic table?

Grateful.

[#2]

Osni

yes it is possible, just copy your expression in the text object.

best regards

Chris

[#3]

I think no, but you can use similar expression in text box to have same sum.......

[osni_campos]

Sorry I was not clear. No need for an alternative, but actually take this value as is on the table.

using macro works, but I would not use this feature.

[#5]

Hi,

Yes, you can put the text as a formula. Let's say you have a table with sales amount, you want to put the total turnover in text. You can put this in text objet, for instance:

='Total turnover: '&sum(Sales)

Hope this helps

[#6]

Do you want the cell value for a particular cell in a row?

Well that can be done by using the same expression and using set analysis to filter the expression for that particular row.

Hope that is what you meant?

[osni_campos]

exactly what I need.

[#8]

Are you able to achieve this? otherwise attach your sample app.

Let me know, if any other questions

Please close the thread if you do not have any questions

[peschu123]

Hi,

I have a similar problem.

I use the expressions sometimes in the Title of the Chart for example Count(Orders) when the dimension in the chart is Orders.

BUT, in my case there is often a difference between the Count() in title and the amount of Orders visible in the chart.

I think this happens when the value for the expression in the chart is null(). Then the Orders are not shown in the chart(which is totally correct) but will be counted in the title. So my title shows 10 Orders but in the chart I just see 5...

The expression in the chart title gets quite complex. It would be nice to simply reference the object ID and get the number of items shown in the chart (macro is not an option) like "GetSelectedCount"

Regards,

Peter

[#10]

Osni,

unless Order is an ID you should better sum(Orders)

if it is an ID, then count(distinct Orders) will give you the right number + 1 null you can remove by -1 or by set analysis {<Order=-{''}>}

best regards

Chris