0

Report Builder Formulas

Christine Cook

April 12, 2021 09:11

None

Follow

Hi all  Is it possible to use a formula and only return the rows based on a result of TRUE

([@[Unit Cost (LCY)]]<[@[Item - Last Direct Cost]])

This returns True and false but I don't want the false rows

regards

Christine

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Bryan Robinson April 16, 2021 19:58

  Without knowing all the specifics, you will need something like this.  

  =@NL("Rows","sales invoice line",,"unit cost","=""<""&NL(""first"",""item"",""Last Direct Cost"",""no."",NF(,""No.""))")

  But I'm guessing on tables and there may be other filters that are needed.