topic Re: Default Value Date on a Table in App Development

Default Value Date on a Table

Anonymous — Wed, 07 Feb 2018 16:30:46 GMT

Hi, I have a table built that Im uploading data to daily, it has a Product and a number of units in it. The number of units changes day on day so the Product list changes too. The Products where invventory goes to 0 will stay in the database as it may be refilled.. Im looking for this table to wake up fully as if I have just selected the most recent value date which has the most recent inventory stock updated. meaning that the list will not show all products if there is no inventory that day.

Product List

=Product_Name

Currently have my units calculated as follows:

Aggr(NODISTINCT Sum({<[Value Date]={'$(=Max([Value Date]))'}>} [No. Units]), Manufacturer)

This means that the products with a 0 value are still showing up on the table as

im looking to put a similar value date constraint on the Product_Name list

any help would be appreciated

Thanks

Re: Default Value Date on a Table

sunny_talwar — Wed, 07 Feb 2018 16:54:01 GMT

May be try this

Only({<[Value Date]={"$(=Date(Max([Value Date])))"}>} Aggr(NODISTINCT Sum({<[Value Date]={"$(=Date(Max([Value Date])))"}>} [No. Units]), Manufacturer))

Re: Default Value Date on a Table

Anonymous — Wed, 07 Feb 2018 18:14:06 GMT

That seems to work great.. Thanks for your help

Re: Default Value Date on a Table

sunny_talwar — Sun, 11 Feb 2018 01:44:38 GMT

No problem at all