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?

I want to display the total(sum of) 'pending invoice amount' on KPI

I want to display the total(sum of) 'pending invoice amount' on KPI

Attaching few screen shots of criteria and results for reference.

Rookie Asked on February 25, 2021 in How To's.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor