About starwars

starwars · 03-17-2023

I have data with 2 tables. purchase table and sales table.I want to create a virtual column in another table, namely the product table with the name "remaining rejected goods" with a formula.with the condition that if there are items with the same ba...

starwars · 03-22-2023

can u check this sirSUM(SELECT(Purchases[Quantity],[Barcode],[Status] = "Rejected item") = [_THISROW].[Barcode]))-SUM(SELECT(Sales[Quantity],[Barcode],[Status] = "Rejected item") = [_THISROW].[Barcode])) i got error:Expression 'SUM( SELECT(Purchases[...

starwars · 03-19-2023

I fixed it but it's still an error. can you fix this formula? I'm a newbie just learning and I'm already stuck SUM(SELECT(AND((Purchases[Quantity],[Barcode]),(Purchases[status] = "Rejected item")) = [_THISROW].[Barcode]))-SUM(SELECT(AND((Sales[Quant...

starwars · 03-19-2023

I tried your suggestion. and I changed it to be like this but it hasn't worked well. can you fix my formula?SUM(SELECT(Purchases[Quantity],[Barcode],AND(([status] = "Rejected item")) = [_THISROW].[Barcode])) -SUM(SELECT(Sales[Quantity],[Barcode],AND(...

My Stats

starwars's Bio

Badges starwars Earned

Recent Activity

auto-calculate between 2 tables if certain conditions

Re: auto-calculate between 2 tables if certain conditions

Re: auto-calculate between 2 tables if certain conditions

Re: auto-calculate between 2 tables if certain conditions