Formula for items with no sales in last 30 days

[auto_724]

I have a inventory application with a sales table.
My sales inline looks like this:

I would like to add slice to my sales table which will only show items that have not been sold in the last 30 days. Can anyone help me with the formula that should be put in this slice?

[Suvrutt_Gurjar]

Welcome to the AppSheet community !

Please try slice filter as

DATE([Data])<TODAY()-30

[auto_724]

Suvrutt_Gurjar:

DATE([Data])<TODAY()-30

I used your formula for my slice

and as a result slices shows sales from 3/14/2020 till 5/7/2021

on 3/14/2020 I recorded first sale in appsheet

so it looks like it shows all sales from 30 days ago from today (first one) till my first sale in appsheet.

it has be something more complicated because formula has to check if there was or was not sale in last 30 days for a particular item

[Suvrutt_Gurjar]

Thank you. Your initial requirement stated

auto_724:

only show items that have not been sold in the last 30 days.

Does the suggested formula satisfy the above condition? Items not sold in last 30 days means items sold before 30 days, right?

[auto_724]

Suvrutt_Gurjar:

auto_724:

only show items that have not been sold in the last 30 days.

OK my bad. items with NO SALES in last 30 days

[Suvrutt_Gurjar]

Thank you. Please update what table sales inline table references and do you wish to have slice on that referenced (or parent) table?

[auto_724]

Please update what table sales inline table references
I do not understand that

do you wish to have slice on that referenced (or parent) table?
slice

[Suvrutt_Gurjar]

auto_724:

My sales inline looks like this:

You mentioned Sales Inline table. Could you please elaborate what you mean by “Sales Inline”? In AppSheet terms this generally means a child table that references a parent table.

Also in general, if you wish to show all the items that have not been sold in last 30 days, I believe one will need a list of all items, that typically exists in the inventory table.

[auto_724]

I have:

• product table
• sales table
• returns table
• purchases table

“sales inline” in my case is a system generated table which reference to sales table

in sales table I am recording all sales with data and product name, like on the screen in previous message

Also in general, if you wish to show all the items that have not been sold in last 30 days, I believe one will need a list of all items, that typically exists in the inventory table.

yes that’s correct so this slice should reference to product table?

[Suvrutt_Gurjar]

auto_724:

yes that’s correct so this slice should reference to product table?

Yes

[auto_724]

ok great, any clue how the formula should looks like?

[Suvrutt_Gurjar]

I believe it will be more than a formula. I believe you may need to consider what is called as referencing in Appsheet ( to interconnect two or more tables) and also please take a look at few inventory sample apps.

AppSheet

AppSheet : mobile apps from spreadsheets : Dynamic inventory - AppSheet

How to build apps for Dynamic inventory using your data in Google Drive, Dropbox, Office 365, and more.

https://www.appsheet.com/Support?q=Inventory&hPP=10&idx=help&p=0&dFR[doc_type][0]=Apps&is_v=1

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.

[auto_724]

yes I know what is reference between table is. I have already use it in my app. Problem is that I do not have any idea how to bait it. Thanks anyway!

[Suvrutt_Gurjar]

auto_724:

yes I know what is reference between table is. I have already use it in my app.

Great. Then you will be able to reference between Sales and Products and pull information from Sales into Product to get the desired sales details for last 30 days.