Messages

1

Help for ParamQuery Pro / Re: Sum percentage

« on: January 10, 2020, 09:09:46 am »

Thanks. Will try this out.

2

Help for ParamQuery Pro / Sum percentage

« on: January 08, 2020, 01:22:52 pm »

May I know is there a way to sum percentage correctly?
See sample below:

I have a formula (column B / column A) * 100%. If the result column is summed, the result is shown as 113.06 but what I want is (total of column B / total of column A) * 100% = 0.77.
May I know is there a way to do so?

3

Help for ParamQuery Pro / Re: Feature similar to ROW_NUMBER() from SQL?

« on: October 24, 2019, 08:22:29 am »

Sure! Thanks 

4

Help for ParamQuery Pro / Feature similar to ROW_NUMBER() from SQL?

« on: October 22, 2019, 01:43:30 pm »

Hi. May I know whether PQGrid able to generate sequential number within each group?

Example
Department: A
1  xxxx
2  xxx
Department: B
1  xxxxxx
2  xxxxx
3  xxxxx

If yes, may I know whether the row number can be exported to Excel?

5

Help for ParamQuery Pro / Adding the merge row?

« on: May 12, 2017, 07:49:18 am »

Hi,

Is there any way to add a new row with merge column in the grid? Attached with the sample picture. Below shown the sample code used.

var rows = manpowerGrid.getRowsByClass({ cls: 'pq-row-edit' });
var rowData = { job: '', grade: '', tagToBU: '', rowTitle: ''  };
var rowIndx = manpowerGrid.addRow({ rowIndxPage: 4, rowData: rowData, checkEditable: false });

Thank you.

6

Help for ParamQuery Select / Single select checkbox

« on: December 14, 2016, 08:13:26 am »

How to allow only one checkbox to be checked in a checkbox column?

Thanks.