This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
You need to create a view in your database that will compute the
transactions table inventory (buy and sell) automatically.
InventoryInventory IDProduct
IDQuantityTypeI001P00110BuyI002P001-2SellSample:Select
ProductID,sum(Quantity) as RemainingQTY gr...
I think there's no such thing that will pop up customized error using
Valid if. You can do is use the Invalid value error but it will always
display under the field you have selected.
you can use if and select function with these
parameters,if(and(count(SELECT(User Login[User Control],
and([Email]=USEREMAIL(),[User
Control]="Admin"),true))>0,[Date]=Today()),true, if(
and(count(SELECT(User Login[User Control], and([Email]=USEREMAIL...