How to calculate Nextday data?

[#1]

Hi All,

I Have data like below. We need to calculate Incoming data

INPUT:                                                          

Delivery Data:

Date	Delivery
01-05-2014	1761
02-05-2014	3109
03-05-2014	2293
04-05-2014	465
Total	7628

Ageing Data:

Date	Ageing Value
01-05-2014	10
02-05-2014	200
03-05-2014	1000
04-05-2014	500

Output :Need daywise data

Date                  Incoming data

01-05-2014        logic=(Next day Ageing data+current day Delivery data)-current day Ageing data

''

''

Ex:

Date                        Incoming data

01-05-2014                (200+1761)-10=1951

same for all days.

Thanks,

Ashok.

[its_anandrjs · Accepted solution]

You can calculate this in the front end like

Dimension:- Date

Expression:- (below(sum([Ageing Value])) + sum(Delivery))-sum([Ageing Value])

[SunilChauhan]

sum(If(Date= Date+1,[Ageing Value])) + sum(If(Date= Date,[Ageing Value]))

[#4]

Hi Anand,

Thanks for ur reply.It working for date wise but i have two more dimensions process and sub process.that

When i applying below function there is chance to get wrong data. and if i add those two dimensions not getting proper

result.

Can suggest any other way.

Thanks,

Ashok.

[its_anandrjs]

Then make changes in the load script of the "Ageing Data"  add new field as [Next Day Ageing] for calculating Next day ageing See the below load script.

"Delivery Data":

LOAD * INLINE

[   Date, Delivery

    01-05-2014, 1761

    02-05-2014, 3109

    03-05-2014, 2293

    04-05-2014, 465];

"Ageing Data":

LOAD * Inline

[   Date, Ageing Value

    01-05-2014, 10

    02-05-2014, 200

    03-05-2014, 1000

    04-05-2014, 500];

NoConcatenate

"New Ageing Data":

LOAD

Date,

[Ageing Value],

if(RowNo() > 1,Previous([Ageing Value])) as [Next Day Ageing]

Resident [Ageing Data] Order By Date desc;

DROP Table [Ageing Data];

And on the front end on the chart write

Dimension:-Date

Expression:- sum([Next Day Ageing]) + sum(Delivery) - sum([Ageing Value])

[preminqlik]

in which table you have two more dimensions?....post sample data with adding two more dimensions