Round number

[marco_puccetti]

Why this statement return me a number like this 12.123?

This is the statement:

=Num(Avg(Date(DT_ATTIVAZIONE_CONTO) - Date(DT_APERTURA_CONTO,'DD-MM-YYYY')),'##.##')

Thanks

Marco

[swuehl]

Because QV handles dates as dual values with a text and a numeric representation.

Aggregating a date difference using avg() will return a number, and num() will format the number according the format code.

[sivarajs]

use Num(exp,'#,##0')

[marco_puccetti]

For other number it works like this, truncating the number:

=Num(Avg(Date(DATA1) - Date(DATA2,'DD-MM-YYYY')),'##')

but it still continue to add a decimal value like: 11.2

Any solution?

Thanks

Marco

[sivarajs]

In properties, fix the number format to integer in  number tab and check.

[Kushal_Chawda · Accepted solution]

Use floor or round on top of the Avg

or

use num( avg( expression) ,'00')

[marco_puccetti]

Ok

Thanks

Marco