Merge two fields from one table then append it with other tables

[karunaramteke]

Hi Experts,

Please find attached qvw for clarity.

From Tab Induslnd I want to merge Emi_Amount and overdue_amount and then concate with other data .

I tried using concatenation but I get 2 rows for single amount.
I also tried in calculated dimension I wrote Amount+Emi_Amount+Overdue_amount , but it dint solve.

Please find below attached qvw for reference.

Please help.

[Kushal_Chawda]

Instead in Dimension, Can you write below formula in expression

=sum(Amount)+sum(Ovedue_Amount)

[karunaramteke]

Thanks for quick response,

It dint solve, I Cant write it in calculated dimension, its giving me error. I have other expression to calculate.

[Kushal_Chawda]

@karunaramteke  What I meant is to write this in expression not in calculated dimension

[Kushal_Chawda · Accepted solution]

see the attached

[karunaramteke]

@Kushal_Chawda Thank you so much1!!!

This also solved and below exp also
aggr(sum(Amount)+sum([Overdue Amount]),Payment_Mode,Transaction_Date,%Lan_ID,PORTAL) 

[karunaramteke]

Can I create one single column in back end, Because I need to show all amount in data dump  like 100, 220, 300 in every row

[Kushal_Chawda]

I would not recommend to use below as simple measure solves the problem

aggr(sum(Amount)+sum([Overdue Amount]),Payment_Mode,Transaction_Date,%Lan_ID,PORTAL) 

[Kushal_Chawda]

Yes. For one of the table you can do something like below

LOAD *,

rangesum([EMI Due Amount] ,[Overdue Amount]) as Final_Amount

FROM Table;

Then in expression you can use simply  Sum(Final_Amount)