Topics »

1

Discussion | Обсуждение / Number Display form problem?

« on: August 30, 2021, 02:49:29 PM »

Hi, I have a problem about display form.

I want to display the number like this:

value1=234567.0

if in QT, I will use the function to finish it

QString::number(value1,'e',4);

the result is 2.3457e+05(scientific notation)!!!!

in limereport version 1.4.7, I get the right result with numberformat, but I get a different result in new version (1.5.0)

numberformat($D{all.3},"E",5,"en-En")

can anyone help me? thanks

2

Discussion | Обсуждение / How to dynamicaly calculate data Averagevalue(AVG Function can't work!)

« on: October 30, 2019, 11:35:23 AM »

I know the function AVG.
I used it like that: AVG($D{data....}.
If it worked well like this: (1+2+3+4+5)/5=3,that's what I want.
but sometimes ,the data is like :0,0,0,0,5,so the function will get the result of (0+...+5)/5=1,this is not the correct result I wanted, the correct result is 5/1=5.
Anyone get good idea? thanks very much.

3

Discussion | Обсуждение / to get Average value

« on: September 04, 2018, 03:01:14 AM »

Hello,everyone!
I have a question about function AVG,my report structure like this
table1.column1,         table2.column,         function1(table1.column,table2.column,para3)
AVG(table1.column1),    AVG(table.column2),    AVG();
the column1,2 data is from datasource, column3 is calculated by a function with parameter,now I want to Get the average value of column,how can I write the script,or is it possible to use the default function AVG to do it ?
thanks!