How to convert Excel formula : count to QV?

[#1]

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.

[robert_mika]

[#3]

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?

[jonathandienst]

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

[#5]

That is not what I want, sorry.

Ok, thanks!

[robert_mika · Accepted solution]

As Jonathan pointed you can use the count in Text box:

[#7]

Thanks Robert and Jonathan! You give me the correct formula!