How to sum all rows in report definition

General
,
1

Hi guys,

Actually i have one requirement. we have cost , tax and total

Based up state cost ,tax and total we will calculate.

yearly wise we pull the report

Tx—COst(2000)----Tax(50)—Total(2500)—22nd july 2022

NY—Cost(1000)-----Tax(10)—Total(1500)—1st feb 2023

Tx—COst(2000)----Tax(50)—Total(2500)-----5th May 2023

TX—COst(2000)----Tax(50)—Total(2500)-----30 august 2023

Invoice Date I searched 1st jan 2023 to 30th august 2023

NY—Cost 1000------tax 10-----total-1500

Tx— Cost–4000----Tax 100----total 5000

It’s possiable to add all rows in single row based up on state by using report definition

Please help me out

Thanks in Advance

2

@kirti

  1. Group based on State(All the records respective to those states will be grouped)-> So State will have sort ->1 after 1-1 group

  2. Then apply sum on various fields

3

@kirti

Hi Mate,

Step 1: Open your RD and in the “Columns” tab of the RD add a new column to the report and set the column source type to " Function"

Step 2: Now in the “Function” filed of the new column enter SUM (Without double quotes)

Step 3: Now in the “Arguments” filed of the new column enter the name of the column you want to sum ( if you want to sum multiple columns, separate their names with commas)

Step 4: Now save the RD and run

Hope this helps you…! Happy Learning

Thanks,

Sudheer

4

Hi @kirti: Below configuration in RD should help.

image.png
image.png984×212 16.4 KB

Thanks.

5

@ArulDevan

I grouped with state and i didn’t sum value in summarize ,Only i have count ,countdisct,min,max and blank

6

Hi @kirti: Please check the data type of property. Sum will be available only for Integer / double / decimal.

Thanks.

7

Hi @kirti: Hope you are planning to use a table / grid in UI. Summary report cannot be added in table / grid because of hierarchical nature of results. Possible solutions to show the data to user.

  1. Give the report access to users directly
  2. Wrap the report with a Data page and use response data transform to transform the data from summary properties to other property and use the data page in your section. Please be cautious on your data volume
  3. Use connect SQL to get the data directly in property instead of transforming it later using data transform. This helps if the data set is huge

Thanks.

8

@ArulDevan

Yeah i changed as decimal , But that values only come in Hierarchical Table , not in Normal Table

How to put the values in Normal table in Ui