LinkedIn
Twitter
Hello Everyone,
Ive created a workflow and in this workflow going through my Lot Number breakdown slice as seen here below.
Slice Formula.
(
[_THISROW]
= MINROW(
"Film Lot Numbers",
"_ROWNUMBER",
and([_THISROW].[Film Lot Number] = [Film Lot Number],[_THISROW].[Film Name] = [Film Name], [Total Stock]>0)
)
)
So we are making sure that the total inventory for each lot number is greater than 0. This is working fine in the app, although some strange things going on, but in the workflow, it is including all the items including those lotnumbers that are at 0 stock.
This is the Result of the Slice.
In My App This is the Result of the Slice.
Saying there are 8 items but there are only 4โฆ 4 is correct.
Clicking on View All, there are only 4. this is correct although it says (8)
I think there is more than 1 issue going on here. Looks like they changed how the inline view are displayed, I like this way better, just there are some bugs, and than the slice to workflow is not working properly?
Solved
1 ACCEPTED SOLUTION
Shout out to Philip & Dan on the Appsheet team for Spending a tremendous amount of time on this problem.
Can now say its officially solved.
In the end, it all came down to an expression throwing some Null values backโ> This is why my inline view Counts โTop Left above Viewโ have also been off.
Final solution:
(
and([_THISROW]
= MINROW(
"Display Lot Numbers",
"_ROWNUMBER",
and([_THISROW].[Display Lot Number] = [Display Lot Number],[_THISROW].[Display Name] = [Display Name],[Total Stock]>0)
), NOT(ISBLANK(MINROW(
"Display Lot Numbers",
"_ROWNUMBER",
and([_THISROW].[Display Lot Number] = [Display Lot Number],[_THISROW].[Display Name] = [Display Name],[Total Stock]>0)))))
)
Thanks @Aleksi and @Steve from the team as well for putting time into this.
Case Closed. Feels great. 
