Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can calculate this in the front end like
Dimension:- Date
Expression:- (below(sum([Ageing Value])) + sum(Delivery))-sum([Ageing Value])
You can calculate this in the front end like
Dimension:- Date
Expression:- (below(sum([Ageing Value])) + sum(Delivery))-sum([Ageing Value])
sum(If(Date= Date+1,[Ageing Value])) + sum(If(Date= Date,[Ageing Value]))
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.
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])
in which table you have two more dimensions?....post sample data with adding two more dimensions