tst exp

[Anonymous]

can anyone help me on this

[Anil_Babu_Samineni]

May be this?

If(ID = Previous(ID), RangeSum(IDCount, Peek('Acc_12months')), IDCount) as Acc_12months;

[Anonymous]

sorry wrong

[Anil_Babu_Samineni]

Not sure, Why it is wrong. PFA

Table:

LOAD RowNo() as RowNo,

[Pr Num],

    Id,

    Date,

    Responsibilty

FROM

rolldata.xls

(biff, embedded labels, table is Sheet1$);

FinalTable:

LOAD *,

  If(Responsibilty = Previous(Responsibilty), RangeSum(Id, Peek('Acc_12months')), Id) as Acc_12months

Resident Table Where Responsibilty like 'ABC'

Order By Responsibilty;

DROP Table Table;

[Anonymous]

thanks- but the values we get are not the expected values

[Anil_Babu_Samineni]

Okay

[Anonymous]

can we do any expressions that gets the required output?
i did tried all the ways possibly - afraid i may left out with empty hands to find expression

any suggesions

[Anil_Babu_Samineni]

I am assuming instead of script, Accumulation is good practice in UI.

Here we go

Rangesum(Below(Sum({<Responsibilty = {"ABC"}>} Id),0),Above(Id,1,RowNo(TOTAL)))

[Anonymous]

thanks

we need it in script only as per our needs

[Anil_Babu_Samineni]

From this thread, It's already stated either from Back end and Front end. I am not sure about is there any third work left of these two (Script / UI)

[Anonymous]

Hi
backend expressions we used but the values are not accuraate as i mentioned earlier- that is what i requestef for anyother expression which yeilds accurate results

with the current expression we r getting sum of the values not the individual values -