"multiplication"
2 Topics
Multiply a constant number by days in month from date table
Looking for help in multiplying a single constant number by the days in the month of the year. example: constant 150 January = 31 days result = 150 * 31 = 4,650 next month (based on date setting) Constant 150 February = 28 Result = 150 * 28 = 4,200 thank you!Solved1.3KViews0likes3Comments
Multiplying 1 column by another - Hopefully straight forward and I am being silly
Hi All, I have 1 column in my Nav_Item table called average selling price and I would like to multiply this by my Free Stock Value measure. For some reason when I perform this return answer is wrong... Anyone have any ideas? For example... Customer Name Product Name Average Selling Price Free Stock Quantity Stock Value Bob Apples £98.12 10,208.44 £250,412.93 Measure for Free Stock Quantity is using Total Quantity measure from my Nav_ItemLedger - Total TOB Approved Unposted from my Nav_SalesLine table here are the measures below... Free Stock Quantity = Nav_ItemLedger[Total Quantity] - [Total TOB Approved Unposted] Total Quantity = Calculate(SUM('NAV_Item Ledger Entry'[Quantity])) Total TOB Approved Unposted = CALCULATE(SUM('NAV_Sales Line'[Outstanding Quantity]),'NAV_Sales Line'[Location Code]="TOB") Hopefully this is explained effectively and long story short... 'NAV_Item Ledger Entry'[Quantity] ...subtract... 'NAV_Sales Line'[Outstanding Quantity]) = Free stock Quantity and then get this Free stock Quantity * Average Sales Price.... Many Thanks, Taylor 😊Solved1.8KViews0likes6Comments