I am writing a Report Builder report which will attempt to show potential
revenue from Quotes and costs by element (material, labor and burden). I am
running into some logic problems with price break arrays. Quoted material
costs may have from 1 to 10 arrayed quantity breaks and an equal amount of
pricing levels. I have been querying by using a series of nested "IIf"
formulas but I have been unable to get the correct result in all cases
although it works in most. Has anyone had experience with or know a better
way to query an array such as this and achieve accurate results?
Michael P. Daniel, CPA
Controller
Nimbus Technologies, Inc.
Phone: (336)-431-4487 ext. 204
Fax: (336)-431-4084
revenue from Quotes and costs by element (material, labor and burden). I am
running into some logic problems with price break arrays. Quoted material
costs may have from 1 to 10 arrayed quantity breaks and an equal amount of
pricing levels. I have been querying by using a series of nested "IIf"
formulas but I have been unable to get the correct result in all cases
although it works in most. Has anyone had experience with or know a better
way to query an array such as this and achieve accurate results?
Michael P. Daniel, CPA
Controller
Nimbus Technologies, Inc.
Phone: (336)-431-4487 ext. 204
Fax: (336)-431-4084