2 Replies Latest reply on May 9, 2018 5:13 AM by Matthew McLaughlin

    Total disappears after extract refresh (desktop 9.2)

    Matthew McLaughlin

      Good morning, all! 

       

      Have a calculated field that disappears after my extract is refreshed.  The calculation is fairly easy math: 

       

          if [Unit Price]> 5000000 then 0 ELSE [WIP adj Qty] * [Unit Price] END

       

      I drag the pill to the text mark and it shows up.  Refreshing the extract and it disappears.  I can revise it to:

       

          iif([Unit Price]>500000,0,[WIP adj Qty]*[Unit Price])

       

      and it's back until the next refresh.  So I re-revise to the original calc, repeat ad nauseum.

       

      Any assistance is GREATLY appreciated!!!

       

      I have attached the workbook in question.  Thanks in advance.

       

      M