Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI, i got a sample data like below,
partt component12 plant_code vendor_code volumn unit_price
A 01 xxx aaa 10 12
A 02 yyy bbb 15 12
A 03 zzz ccc 10 16
B - jjj ddd 5 6
i am able to display 35 only in one row ,how to display 35 in remaining two rows as well ,
Expression :aggr(sum(volumn),partt) ....what is wrong with his expression
Thanks
Can you post your file... will be easier to work with a sample
what i tried to get new_column is:
aggr(sum(sum(volumn )* sum(unit_price)),plant_code)-(Aggr(NODISTINCT Sum(volumn),partt) * sum(unit_price))
but i am getting null
Okay
sample file
May be this
sum(TOTAL <partt> volumn * unit_price) - Aggr(NODISTINCT Sum(volumn),partt) * sum(unit_price)
perfect ,thanks a lot