Equation Solution

csandwick · ‎11-09-2017

I have linked the file for the report with two databases, Item variant, and Item Ledger, under the Bushel Conversion link along with a picture link that shows each apple variety totals that are the end result. Each item(apple variety) has a variant code based on the variety of the apple and it's packaging type. I need to take the quanitity from the Item ledger and multiple it by the corrosponding standard weight from the Item Ledger, then divide by 40 to convert the quanitity into bushel units. The standard weight is different depending on what the variety and the packaging it is.

Bushel Conversion

Variety Totals

(Everything is in bushels, the far right amounts are the grand totals to use)

v-chuncz-msft · ‎11-09-2017

@csandwick,

Simplify your model please. Based on my experience, you may use FILTER Function and SUMX Function.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.