0

NP formula Help

Tim Freeman

May 21, 2019 12:42

None

Follow

I am having issues getting this formula working in Jet.  Any help would be greatly appreciated.

=NP("Formula","=iferror(value(left([@[SKU Lead Time Calc]],LEN([@[SKU Lead Time Calc]])-1), "")")

I wrote this formula in the Table Builder but it will not work while running the report.

Thanks in advance.

Tim

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Harry Lewis May 21, 2019 17:11

  Hello Tim -

  Try this:

   

  =NP("Formula","=IFERROR(VALUE(LEFT([@[SKU Lead Time Calc]],LEN([@[SKU Lead Time Calc]])-1)),"""")")