Average of a calculated field

Comments

• -=Oleg=-

  October 2013 edited 5:11AM

  Hi.
  
  You can do it in FastCube 2.
  
  1. Create simple "sum" measures 'A' and 'B'
  2. Create calculation measure 'C' with script:
  result := measures.currentvalue + measures.currentvalue;
  3. Set function for total in measure 'C' as "average"
  
  
  Best regards,
  Oleg Pryalkov.
• hrnickel

  October 2013 edited 5:11AM

  wrote: »

  Hi.
  
  You can do it in FastCube 2.
  
  1. Create simple "sum" measures 'A' and 'B'
  2. Create calculation measure 'C' with script:
  result := measures.currentvalue + measures.currentvalue;
  3. Set function for total in measure 'C' as "average"
  
  
  Best regards,
  Oleg Pryalkov.

  
  Data output should explain of following end
  
  A B C D
  1 5 6 9
  2 6 8 9
  3 7 10 9
  4 8 12 9 = average from C
  
  Please help me
  
  
  
• Xavi

  March 2014 edited 5:11AM

  As suggestion for a future version, I would ask you to be able to enter directly the expression, in the properties option, not indirectly calling a function that then you need to call.
  
  
• -=Oleg=-

  March 2014 edited 5:11AM

  Hi.
  
  We plan to do it in future.
  
  Best regards,
  Oleg Pryalkov.