Range sum prbolem

[swarnendu]

Hello guys,

I am facing a problem need some help.

I am just calculate like

sum(total qty)*80/100.

I am fetching data from excel.I want to pick the actual nearest qty from excel and with respect this i want to calculate the value .

example: 80% of my total quantity is let 1500

i am using range sum above function.I need the value near of 1500 which is taken from qty field from raw excel.

but the fact is its not working for me.

i am just attach  screenshot please check this and if you have any solution then please provide me.

[MK_QSL]

Recipe for an ABC Analysis

Recipe for a Pareto Analysis

you will get little idea from this..

[sunny_talwar]

I am not sure I understand the issue, but would you be able to share the Excel file to look at it.

[PrashantSangle]

To achieve it You have to perform complex logic.

Possible logic could be

create a variable which store your value to which you want to compare

then crate a temp table which contain difference between actual qty and compare qty.

then organize it asc order, using order by on newly compare qty.

then using peek() take 1st row or  rank() to achieve your desired requirement.

Regards,

[swarnendu]

Thanks for your reply.

i need to calculate cumulative sum using expression