Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can you share sample app?
Try
Sum({<CALMONTH = {">=$(=date(YearStart(Max(CALMONTH)),'YYYYMM')) <$(=date(max(CALMONTH),'YYYYMM'))"}>}
i wish but i am having client data with me,i will loose my job
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
I tired your expression but it is not working it is coming as nulls
How R_CalMonth and CALMONTH are related?
based up on
part,supplier,plant,fiscalyear combination
Based up Key6
Any Suggestion on how to write the expression please