requirement for sum

[kishorj1982]

hi all,

I have requirement as per below,

I have values from  Jun to december.

Value of jun is base

July values is= Value of June+ Value of July.

august values== Value of June+ Value of august.

september values= Value of June+ Value of september.

Can you please suggest how to achieve this.

Thanks

[Anil_Babu_Samineni · Accepted solution]

When we talk related base is june, You could try

Sum({<Month = {'Jun'}>}Sales)+Sum(Sales)

[techvarun]

Check the attached app

[kishorj1982]

Thanks Anil,

Can you please suggest how to achieve this in backend.

thanks

[techvarun]

Use below script if you want to achieve this in backend

TEST:
LOAD * INLINE [
    Month, Sales
    Jan, 10
    Feb, 20
    Mar, 30
    Apr, 40
    May, 50
    Jun, 60
    Jul, 70
    Aug, 80
    Sep, 90
    Oct, 100
    Nov, 110
    Dec, 120
];


Join Load Sales as BasePrice Resident TEST Where Month ='Jun';


Load*, If(Month = 'Jun',Sales,Sales+BasePrice) as FinalPrice Resident TEST;


DROP TABLE TEST;

[Anil_Babu_Samineni]

Perhaps this?

File:

Load Month,

         Sales

From Table;

Final:

NoConcatenate

Load Month, Sum(Sales) as Sales Resident File Where Match(Month, 'Jun') Group by Month Order By Month Desc;

Left Join (Final)

Load Month, Sum(Sales) as Sales Resident File Group By Month;

Drop Table File;

[kishorj1982]

can u plz suggest how to achieve this by using if else condition in expression

[Anil_Babu_Samineni]

Are you playing in community?? Not sure, What requirement you have. I am sorry