I'm trying to create an item search with a formula column that holds the result of: {memberitem.averagecost}*{memberquantity} -or- it could hold {memberitem.vendorcost}*{memberquantity}
It isn't working very good. Some fields have good looking data and some are off.
There is a help in SuiteAnswers (Answer Id: 21631), but it is for searching for JUST ONE item and getting it's member's cost. It isn't for search for hundreds of kit items and displaying all of them (one per line) with each line having it's member's cost.
Any ideas?