SET ANALYSIS

[Anonymous]

Hello Experts,

I am stuck with a problem and I need your help to resolve it

SUM(     {$<     DWH_IM_MOVEMENT_TYPE={'2'},   DWH_IM_DATE={$"GI_LAST_DATE"}  >}  GI_IM_QTY )

What I want to achieve is to return the GI_IM_QTY where DWH_IM_MOVEMENT_TYPE=2 and DWH_IM_DATE=GI_LAST_DATE and it calculates it for every item

in other words if we can write the set analysis of

SUM(IF(

DWH_IM_MOVEMENT_TYPE=2 AND

DWH_IM_DATE=GI_LAST_DATE,

GI_IM_QTY))

without any selection it will might solve the problem.

I will really appreciate is someone can help on this.

[aveeeeeee7en]

Hi

Try this:

SUM({$<DWH_IM_MOVEMENT_TYPE={'2'},DWH_IM_DATE={'$(=Max(GI_LAST_DATE))'}>}GI_IM_QTY)

Regards

Aviral Nag

[Anonymous]

Hi Aviral,

it looks like we are getting closer the problem is now it only shows you the GI_IM_QTY of the last day which is usually yesterday date anything before that it doesn't show you any stock.

I will be very thankful if you can help in this please