Hi ray,
My source is like this
UOM PARENTMEASURE PARENTLEVEL CURRENT LEVEL PARENTROLLUPOPERATOR AMOUNT
COST PROFIT 0 1 -
DIRECTCOST COST 1 2 + 75
INCOME PROFIT 0 1 +
NETINTERESTINCOME INCOME 1 2 + 100
PROFIT PROFIT 0 0 +
INDIRECTCOST COST 1 2 + 10
my source data is like this.here i want to implement loop.
if we observe cost(underparent measure) is parent for directcost and indirectcost and for that operator is + .so we should add amount then that we should assign to cost(75+10=85)
same like netintrestincome is child of income so income should 100
finally profit is parent of cost and income(but here means in first record for cost and profit parentrollupoperator is '-(minus) and in third record for income and profit rollup operator is '+')
so profit=income-cost
so here for understanding i given some records but in future we wil get more records
i need to implement looping here(lowerlevel data should add r minus to upper level depend upon operator
Thanks in Adavance
vin...