This topic contains 2 replies, has 0 voices, and was last updated by JohnCCole 7 years, 2 months ago.

  • Author
    Posts
  • #22775 Score: 0

    ryan.austria
    • Contributions: 0
    • Level 1

    Is there a way to get a result with non-repetition of vendor name in saved searches if that vendor have multiple transaction?

    Sample scenario :

    As seen with the screenshot, one supplier (Best Inc. Limited) is equivalent to one transaction.

    What we wanted to be the output or expected result is one supplier/vendor with multiple transaction.

    See below screenshot.

    Note : It cannot be done with saved report because I have already created formula for 'Price' column.

    Thank you.

    Attached Files
    This is a cached copy. Click here to see the original post.

  • #22776 Score: 0

    Olivier Gagnon NC
    • Contributions: 0
    • Level 1

    This is not possible. Export your results to Excel, then do some excel gymnastics to achieve that there.

  • #22777 Score: 0

    JohnCCole
    • Contributions: 0
    • Level 1

    Sorry didn't see the price was a formula field. Please disregard the below.

    If there are no formula, sum, group fields in the search results could you not create an Advanced PDF Template? In the advance PDF template you could track the previous company with a variable so you could compare it against the current row, and if the company is the same as the previous don't print it.

You must be logged in to reply to this topic.