Summary Report Columns showing Month End

Question

Simple Account Database with two tablesfirst table - account name and account numbersecond table - account value and dayReport i am looking for is a summary report by month showing end of month valueName&nbsp; &nbsp;Jan&nbsp; Feb Mar etcSmith&nbsp; 10&nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; 30The summary report I get adds all the values in that month togetherobviously new to qbase, thanks in advance for any help------------------------------Nicholas Neilio------------------------------

markshnier__you · Answer

Well, assuming that in fact you have data for every day of the moth for every account, then you can make a checkbox formula flag field on the child daily values table called [Last Day of the Month?].

[Date] = LastDayOfMonth([Date])

Then add that filter to your summary report.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

nicholasneilio1 · Answer

thanks, I thought of that route, but was unsure if there was a function/feature inherit to the software,Nick------------------------------Nicholas Neilio------------------------------

Forum Discussion

Summary Report Columns showing Month End

Related Content

Summary Reports

Default column widths on embedded reports obscuring data

Show related records

Any way to restrict showing more columns?

Rearrange Fields/Columns in table