Expression

[suvechha_b]

Hi ,

How to write the expression for Inbound Units and Inbound Value.

As, in the script ,

load

    'IO' as [Type Indicator],

  [Trans Date],

  product_key,

  0 as division_key,

  [ordered_quantity] as [Quantity],

  [inbounds_value] as [Sales Value],

  0 as  [Cost of Sales]

FROM [..\00 QVD Source\InboundOrders.qvd](qvd)

where fiscal_year = 2016

and fiscal_period=10

and product_key=160 

;

division_key is 0 .

How to write the set analyis ignoring the division_key  as Inbound is not dependent on division_key.

Thus, the value is linked to NULL Main Division.

Sample attached.

Thanks,

[sunny_talwar]

Try it with the TOTAL qualifier. Not sure which fields need to be used based on your actual data, but I guess you can play around with it. So far I have this for you

SUM({<[Type Indicator] = {'IO'} >} TOTAL [Sales Value])