4 Replies Latest reply: May 21, 2013 9:19 AM by Janne Vauhkonen RSS

    Duplicate problem with alt-statement

      Hi
      I have following script in expression.
      =sum(if(alt([Billing Day],0)=0,([Order quantity_WMENG]*Net_Price/ExhRate,0))

      For some reason this this formula sums everything twice and I can't see what is the problem. Would you have any ideas. The formula calculates properly without if(alt statement, but with that all results are multiplied with 2. There shouldn't be any duplicate rows in my data model; all these needed values are only once in my data model.
      Many thanks already beforehand
      Regards
      Janne