Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
independent expression of the formula I need to grab the value of the cell in question.
We can achieve this by using macros. You can call the chart and then play with its cell values.
But you need to get Value where Name is "aaaaaaa" then use
sum({<Name = {"aaaaaa"}>}Value)
or you can also try to use ranking and then fetch the row which you want. something like that may be
You can mark any response as Helpful Answer or if you have find your answers then mark it as Correct Answer
Why should I sum a field with strings in it?
I think you got me wrong. The field orders is always filled with values. It never gets null() or empty. And even distinct counting leads not to same result like in the chart. The problem is that the expression in the chart gets null() in some cases. I will post an example in another thread. I think that will clear the situation up...
Regards,
Peter