I want to display the total(sum of) ‘pending invoice amount’ on KPI
I Have created a saved search to get the value of ‘pending invoice amount’ with the help of formula (here is the formula ({quantityshiprecv}-nvl({quantitybilled},0))*{rate} ) it is showing me the right amount for total ‘pending invoice amount’ but when I apply a summary type of Sum to it for KPI then it is showing wrong amount. Why? How can I resolve it?
Attaching few screen shots of criteria and results for reference.