how to compare two expressions dynamically

[#1]

Hi All,

I am developing Inventory Adgeing report for that I am facing some problem. I have attached excel file:

In that Suppose I have Material A for that I am having Total BUM Qty : 1480.25 but Total BUM Output Qty is 10954.735,

So I want to compare BUM Qty and BUM Output Qty upto when BUM Qty is less than BUM Output Qty that records I want to capture.

In attached file I want Output qty and only red colour rows.QlikTech Admin

[its_anandrjs]

Can you explain more what output you required for first 5 rows.

[#3]

Dear Rupali,

Try the app attached.

Regards

Rahul

[#4]

"So I want to compare BUM Qty and BUM Output Qty upto when BUM Qty is less than BUM Output Qty that records I want to capture."

Can you further explain what this means? I do not understand your requirement.