reg:bi quireies of fileds sum into another field?

[Former Member]

hi,

we have two queries.

we take one filed from both of quiries .

we need sum of these two fileds sum into another filed.

note: we have multiple rows in both fileds.we need to put sum in another filed.

thanks

raja

[Former Member · Accepted solution]

Hi,

Please Follow Below Steps For Your Requirement.

But One Common Field Must be in both the Queries.

1) first drag input form into dash board ... and drag the first query data to dash board output node to the tables form ..

2) next drag the second query data into dash board and output node to the table form .

3) now drag the the first outputnode query to filter data input node .

4) and next similarly second query output node drag the outputnode to second filter input node .

5) finally filter 1 , filter2 output node to union operator from there u drag to table input node .

6) just click on union operator u can see list of the fields from two tables select f1 it will appear like (rightmark) and simlarly select f2 .

7) now u can create f3 variable of type number in form . and goto properties tab click on general go to formula

take your two fields from data fileds like this f1 + f2 . check your formula .

😎 finallly select one key field in union operator .

now deploy and comile u will get the following output

Note : here we have pass the datatypes decimal from Back end its mandatory .

Thanks & Regards ,

Subbarao Chinta