You are asked to produce sales value for the month using sales order line items (sales price per item x quantity sold) what do you use to achieve this in a calculated column of a calculation view? There are 2 correct answers to this question.
To produce sales value for the month using sales order line items (sales price per item x quantity sold), you can use a calculated column of a calculation view that performs the multiplication of the two columns and applies a transparent filter and a non-equijoin to restrict the data to the desired month. A transparent filter is a filter condition that is applied to the data source of a view node and is propagated to the subsequent nodes. A non-equijoin is a join condition that uses operators other than equality, such as greater than, less than, or between. For example, you can use a transparent filter to filter the sales order line items by the month of the order date, and then use a non-equijoin to join the sales order line items with the sales price table by the order date and the valid from and valid to dates of the sales price.Reference:Transparent Filters,Non-Equijoins,Create Calculated Columns.
Limited Time Offer
25%
Off
Elina
4 months agoBulah
4 months agoFernanda
4 months agoAmie
4 months agoPearlene
4 months agoCrista
5 months agoCasey
5 months agoJanae
5 months agoTommy
5 months agoLeeann
5 months agoJulie
4 months agoQuentin
4 months agoLavina
4 months agoJonell
5 months agoLynelle
5 months agoVernice
5 months agoKatina
5 months agoOcie
6 months ago