Previous 6 months sum in Script level ?

[ganeshreddy]

Hi All,

How can i calculate previous 6 months Sales here in below script.

Note: In UI level i can achieve this, finding difficulty to calculate in script level .

Thank You,

Cheers,

Ganesh

[Anonymous]

use set analysis

sum({<yourdatefield={'>={$(=addmonths(max(yourdatefield),-6))}<=yourdatefield{$(=max(yourdatefield))}'}>}sales)

maybe you need to adjust expression

[ganeshreddy]

Hi Rudolf,

I suppose we can not use set analysis in script. I want to calculate in Script as like Sum(Sales) which i did in script.

Cheers,

Ganesh

[giakoum]

something like the attached?

[giakoum]

note the set statement :

SET DateFormat='DD/MM/YYYY';

and use a calendar :

Understanding the Master Calendar (video)

[abhaysingh]

Hi ioannis,

if i want Current Month vs next 3 rolling month than what i need to do?

thanks

[giakoum]

AsOfMonth:

load

Month as Month_AsOf,

Month + 1 + IterNo() as Month

Resident tmp_SO

while IterNo() <= 3;

plus in IterNo instead of minus

and 3 instead of 6 in the while clause

see Calculating rolling n-period totals, averages or other aggregations for more details / suggestions

[pratap6699]

sum({<datefield={">=$(=addmonths(max(datefield),-6))<=datefield$(=max(datefield))"}>}sales)

use if() in script level