Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to tell the rows in a table, because I want to make a formula with it.
I want to do this formula: an amout / number of rows.
In Excel you can tell the rows with the formula: count(... : ...)
Thank you.
As Jonathan pointed you can use the count in Text box:
Thanks for you answer.
But how can I hide the columns: NoOfRows() and =sum(Points)/NoOfRows()?
And how can I the answer of =sum(Points)/NoOfRows() put in a separate textbox?
Hi
Why do you want to add the columns and then hide them? You can use a conditional on the expressions tab, hide column in the presentation tab (straight table), or disable the expression on the expressions tab.
You can't use NoOfRows() in a text box, it is only valid in a chart or table object. The number of rows is determined by the distinct dimension values - in your case
Count(Distinct Face)
will return the same value.
HTH
Jonathan
That is not what I want, sorry.
Ok, thanks!
As Jonathan pointed you can use the count in Text box:
Thanks Robert and Jonathan! You give me the correct formula!