How to display particular range values in table

[#1]

Hi All,

I want to display particular range value (from 31111 to 31121) under sales  AND

(from 41112 to 41118) under Materials column. Please find the attached QVW file for referance.

[anbu1984]

Which field in your model is Material Cost BOM?

[#3]

There is no field in data model as Material cost BOM

MAterial cost BOM is Ledger values From 41112 to 41118

Material Cost BOM is defined in expression i.e

=If(Index(vAllAcct,41112+(RowNo()-1)) And 41112+(RowNo()-1) <= 41118,41112+(RowNo()-1))

We need to write expression for new column(Material Cost Actual) to calculate below result

150 is calculated as 100 + 100*(500/1000)