title: Measure is being summed up in Cognos
body: <p>I'm having a weird issue with Cognos. You can see the issue in the below image:</p>
  
  <p><img src="https://i.stack.imgur.com/yXuRm.png" alt="List result"></p>
  
  <p>Each <code>Credit Alert</code> can have a single adjustment associated with it. But the amount is usually in the hundreds or thousands. But here clearly we just have a sum up of all the <code>Adjustment Amounts</code>.</p>
  
  <p>Below I attached the Cognos Framework Manager model (<a href="https://i.stack.imgur.com/1O47w.jpg" rel="nofollow noreferrer">large image link</a>) inside the modelling layer. As you can see <code>F_CREDIT_ALERT</code> has a link to <code>D_INVOICE_ADJ</code> which has a link to <code>F_INVOICE_ADJ</code> (which has the measures <code>Request Amount</code> and <code>GST</code> which are used to create the <code>Adjustment Amount ex GST</code>).</p>
  
  <p><img src="https://i.stack.imgur.com/1O47w.jpg" alt="Cognos Framework Manager model"></p>
  
  <p>Any help with this issue would be very appreciated. Also any general tips/comments about the model would be helpful too.</p>
  
  <p>Thanks</p>