How do I get this report to summarize?

5 views
Skip to first unread message

kim....@sokiltrucking.com

unread,
Nov 20, 2018, 5:25:20 PM11/20/18
to ParaSQL Support

Report image.png


F(x) report column looks like: 

If (Sokil_GL_Account_Items.Account_Number = 113100, SUM(Sokil_GL_Account_Items.AR_Amount), 0)

How do I get the report to provide a summary on a F(x) column?  I have Roll Up Style report turned on.


Support

unread,
Nov 20, 2018, 6:32:37 PM11/20/18
to ParaSQL Support
Although it is not completely clear what you are trying to accomplish with the example, this might be what you are after:

SUM( If(Sokil_GL_Account_Items.Account_Number = 113100, Sokil_GL_Account_Items.AR_Amount, 0) )

In any report that is grouped, the operations are computed line-by-line and the result aggregated (in this case SUMed) over the group and any subgroups.

Reply all
Reply to author
Forward
0 new messages