logo
Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Sekharg  
#1 Posted : Tuesday, December 6, 2022 12:14:59 AM(UTC)
Sekharg

Rank: Member

Groups: Registered
Joined: 2/19/2021(UTC)
Posts: 10
India

Thanks: 1 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
epf  
#2 Posted : Tuesday, December 6, 2022 10:43:10 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,208
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 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"
Users browsing this topic
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.