9 Replies Latest reply: Mar 27, 2014 10:07 AM by Michael Maeuser RSS

    Formula Problem (Set Analysis)

      Guys, good morning,

       

      I have an Excel file extraction from a financial parts that keeps repeating the same information in many lines in the first columns, and then the last columns it changes. I want to get the total for those first columns, so, I wrote this formula in my script:

       

      IF([Claim #]=PREVIOUS([Claim #]),'0','1') as UNIQUE_FLAG

       

      after that, I created this other formula to sum the total approved from the Claims:

       

      =SUM({<[UNIQUE_FLAG]={1}, [Status Claim] -={Cancelled}>}([Total Approved])*[Rate])

       

      Problem is, it seems it is getting always the double (as if it is sum when UNIQUE_FLAG = 1 and UNIQUE_FLAG = 0).

       

      When I choose for one single Claim, it becomes very clear that it's doubling the value.

       

      Can you guys help me out in this problem?

       

      I'll attach a pic of it...