Rank: Member
Groups: Registered
Joined: 2/19/2021(UTC) Posts: 10  Thanks: 2 times
|
Hey Eric,
I need to customize my Total Sum value column as below
[Sno] [Particulars] [TypeOf] [Product 1]
1 From House + 1000
2 Customer Order 1000
3 Leakage - 10
4 Damage - 3.5
5 NetSale - 986.5
Net Amount 0
sorry for the format I cant able to create a table here
Total Sum = 1000-10-3.5-986.5 = 0
This is related to Reconciliation of stock
Please provide any sample or solution
Thanks,
Sekhar G
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
you can use the "Custom SQL" property to modify the SQL generated and perform the calculation in SQL.
Otherwise, the other option is to use "Cell Script" to perform the calculation.
Check sample "05-Scripts\503-Final Script - Change result table.srex"
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
