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.