on 02-13-2015 10:05 AM
I'm using SBO 9.1 PL4 and a segmented chart.
I have added a udf field in my marketing document on which i want to populate the available balance using formatted search and the following query
SELECT SUM(T0.DebLTotal - T0.DebRLTotal - T0.FtrODRLSum ) AS 'Budget Balance'
FROM OBGT T0 WHERE T0.AcctCode = $[$39.94.0]
GROUP BY T0.AcctCode
The query does not pick the budget amounts as the code does not pick '-SYS......' codes.
Kindly help me amend it so that it picks the '_SYS.....' codes
I have attached screen shot of both segmented chart screen and normal chart screen
You assistance is highly appreciated
Regards
George Njuguna
Hi George
try the below FMS
SELECT SUM(T0.DebLTotal - T0.DebRLTotal - T0.FtrODRLSum ) AS 'Budget Balance'
FROM OBGT T0 WHERE T0.AcctCode = $[POR1.ACCTCODE]
GROUP BY T0.AcctCode
--Manish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi George,
You may try this first:
SELECT SUM(T0.DebLTotal - T0.DebRLTotal - T0.FtrODRLSum ) AS 'Budget Balance'
FROM OBGT T0
JOIN OACT T1 ON T1.AcctCode=T0.AcctCode WHERE T1.FormatCode = $[$39.94.0]
GROUP BY T0.AcctCode
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try this query:
SELECT SUM(T0.DebLTotal - T0.DebRLTotal - T0.FtrODRLSum ) AS 'Budget Balance'
FROM OBGT T0
JOIN OACT T1 ON T1.AcctCode=T0.AcctCode WHERE T1.FormatCode = $[$39.94.Number]
GROUP BY T0.AcctCode
OR
SELECT SUM(T0.DebLTotal - T0.DebRLTotal - T0.FtrODRLSum ) AS 'Budget Balance'
FROM OBGT T0 WHERE T0.AcctCode = $[$39.94.Number]
GROUP BY T0.AcctCode
Thanks & Regards,
Nagarajan
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.