"multiplication"
3 Topicscannot connect to server for the PRIAD training
Hi, recently we conducted the Paginated Reports in a Day training inside our Company. Since not everyone was able to join, we advised that the Users might download the materials and go through the training at their own pace. The problem is, we cannot establish connection to the priad.database.windows.net server, at least since last Thursday, Aug 17th. Is anyone aware of what the issue is? Is the server down for maintenance or something? When could we expect it to be restored?2.1KViews5likes5CommentsMultiply 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.3KViews0likes3CommentsMultiplying 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