13 Replies Latest reply: Sep 14, 2017 10:25 AM by Shraddha Gajare

# how to write the expression

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

• ###### Re: how to write the expression

can you share sample app?

• ###### Re: how to write the expression

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

• ###### Re: how to write the expression

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

• ###### Re: how to write the expression

Try

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

• ###### Re: how to write the expression

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

• ###### Re: how to write the expression

How R_CalMonth and CALMONTH are related?

• ###### Re: how to write the expression

based up on

part,supplier,plant,fiscalyear combination

• ###### Re: how to write the expression

Based up Key6

• ###### Re: how to write the expression

Any Suggestion on how to write the expression please

• ###### Re: how to write the expression

Hi,

try this :

=aggr( rangesum(above( sum(CALMONTH), 1, rowno() )), VOLUME)

• ###### Re: how to write the expression

HI,

It is giving only aggr value....

• ###### Re: how to write the expression

Is this  requirement is not possible to achieve ?

• ###### Re: how to write the expression

It is possible to achieve but scenario is not clear.

May be one of the experts can help you.