how to write the expression

[kunkumnaveen]

Hello All,

can any one help me in achieving this requirement.....the thing is i need to show sum of volume against recommended R_Calmonth column  what i mean is

what i need to show for   R_Calmonth      201707 =201704+201705+201706 which is  1600+1600+1768  =4968

                                 for                            201708=201704+201705+201706 +201707 which is   1600+1600+1768+400=5368

                                                                  201709=201704+201705+201706 +201707+201708 which is   1600+1600+1768+400=5368(beacuse i dont have any volume for 201708)

Expression i tried is

                             Actual:  Sum({<CALMONTH = {">=$(=YearStart(Max(CALMONTH))) <$(=max(CALMONTH))"}>} VOLUME)

but i am not getting expected output

Any suggestion plz

thanks

Naveen

[shraddha_g]

can you share sample app?

[shraddha_g]

Try

Sum({<CALMONTH = {">=$(=date(YearStart(Max(CALMONTH)),'YYYYMM')) <$(=date(max(CALMONTH),'YYYYMM'))"}>}

[kunkumnaveen]

i wish but i am having client data with me,i will loose my job

[shraddha_g]

You can create a Sample app to test with Dummy data with same scenario.

It will be easy to help you better to understand you data and  data model

[kunkumnaveen]

I tired your expression but it is not working it is coming as nulls

[shraddha_g]

How R_CalMonth and CALMONTH are related?

[kunkumnaveen]

based up on

part,supplier,plant,fiscalyear combination

[kunkumnaveen]

Based up Key6

[kunkumnaveen]

Any Suggestion on how to write the expression please