REPORTS

[ANDREWDAVENPORT]

I HAVE BUILT AN INVENTORY TRACKING APP AND WOULD LIKE TO KNOW HOW I CAN CREATE A SIMPLE REPORT ON THE DOLLAR AMOUNT TOTAL I HAVE ON HAND FOR A CERTAIN PERIOD OF TIME. EXAMPLE: ON HAND QTY COST TOTAL FROM 1/1/21-12/31/21. CAN ANYONE HELP ME?

[Craig_QREW]

Of course, I recommend creating a template that you can attach in the automation section of AppSheet. This would allow you to include all kinds of information and you would not have to learn any new expressions as the template would be the same type of expression as AppSheet is. Here is a free video on creating templates from appsheettraining.com I highly recommend using their free and for purchase resources to help you. 

I can tell you that an expression that looks like this:  SUM(SELECT(Inventory[Cash],YEAR([Date])=YEAR(TODAY())-1))

will give you the cash only from last year. Assuming the cash gained each time is recorded. 

Please let me know if I can be of more help, and I will happily reply.

Craig 

QREW Technologies

SELECT() 

YEAR() 

TODAY()