expression

[fmazzarelli]

hi,

a simple question (I hope)

Using expression, is it posible divide a value?

How to do it?

Example

field: invoice_number

files: total_value

new fields: Total_value / (count(invoice_number))

[swuehl]

In general, you shold use aggregation functions around every field in an expression.

Maybe like

=SUM(Total_value) / COUNT(invoice_number)

[PabloOrtiz]

!Hello Fabio, attached an simple example, maybe you help

[fmazzarelli]

hi, your suggest is fine.

but if i create a chart (digital display), I obtain this result?

What is it wrong?

[swuehl]

The expression itself is working e.g. in a text box?

Can you upload a small QVW sample file?

[fmazzarelli]

thanks for your suggest.

It's works