0

NP(Join, Purchase Price (LCY), ", ")

Jógvan Juel Rasmussen

April 05, 2024 06:51

None

Follow

Hi,

I am trying to join different purchase prices, and set it behind the item name, to show how many different prices the item has had in fx the last 6 months, ie:

Product A ($1.30, $1.45)

Product B ($2.25)

Product C ($4.50, $4.45, $4.85)

 

When I get the result, the prices have 20 decimals, filled with zeros as this:

Product A ($1.30000000000000000000, $1.45000000000000000000)

Product B ($2.25000000000000000000)

Product C ($4.50000000000000000000, $4.45000000000000000000, $4.85000000000000000000)

 

Is there a way to just get 2 decimals, as I have tried the ROUND functions, but then the fomula returns #VALUE

 

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  CascadiaDataworks June 27, 2024 21:58

  If you need to see each price, I have two questions:

  1. Will you be using the Jet Hub for this report?
  2. Do you know the maximum number of prices any product could have?

  If this won't be used in the JetHub AND you know the maximum number of results, I have an odd solution using NL(Filter), NL(Join), and Excel's Textjoin function.

  If you DON'T need to see each price you could just use the NL("CountUnique") on the Amount field when filtered by date and item number which would count how many unique Amounts it finds.