Monthly reporting

[mapodei100]

Is it possible to do monthly reports in bubble: for example total sales for a particular month. I tried this and it is not working. Thanks in advance.

[firstfifteensoftware]

In short, yes.

I have a sale summary report I can generate for my clients. For a set of days, it shows total sales, then various calculated amounts for each row in my RG.

BUT I can do this because the calculated values are stored in my db. Are YOUR calculated fields stored? If not, you may need to dynamically calculate the values.

What exactly is NOT working for you?

[mapodei100]

We are into equipment rental. We calculate the number of hours an equipment has worked, by subtracting the starting hours from the ending hours example 543-540=3 hours. so in a month, I will like to know the number of hours an equipment has run. I can see the total number of hours just as indicated at the top, but when I filter it with the dates, then it goes to zero. Thanks for your input. The worked hours is installed in the database.

[mapodei100]

Any help

[yoroanoke]

When you filter by date, does the whole database go blank, or just “worked hours”?

And am I correct in thinking you want the “Monthly Report” to look just like your photo, but filtered by specific dates. Are you trying to have summation or other total functions for each category?

[mapodei100]

Thanks for your input when I fiter by the date, the doesn’t go blank, but the calculated field goes blank, total machine hours. Kindly check the second picture

[mapodei100]

[quote=“mapodei100, post:6, topic:235832, full:true”]
Thanks for your input when I fiter by the date, the repeating group doesn’t go blank, but the calculated field goes blank, total machine hours. Kindly check the second picture

[mapodei100]

Any help

[firstfifteensoftware]

OK, I don’t know if this would work for you, but try this.

Your RG has a field for worked hours, correct?

And you want the summary at the top to show (in your example) 16.00, right? Like this?

IF this is what you need, you can do this pretty easily with a simple text field. In this field, you can do a sum of all the work hours displayed in your RG.

For example, here is what it looks like when I want to display the sum of all the asking prices of my items for sale:

And your display can have totals anywhere, like this:

Does this help at all?

[mapodei100]

Thanks so much.

[firstfifteensoftware]

If you need a little more help, let me know.