Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the script, I have a table with Item and attributes, and another table with Item, Bin, Inventory.
In the layout straight table, my columns are Item, attributes, and Inventory in Bin A with below formula:
sum({<Bin={'A'}>}Inventory)
The problem is, if an item doesn't exist in Bin A, the row is showing null although the item has attributes.
I have checked "Include 0 values", so I have no idea what the problem is.
try this
sum({<Bin={'A'},Bin=p(Bin)>}Inventory)