Search found 1 match
- Mon Oct 19, 2009 2:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Calculate Average in Rules
- Replies: 4
- Views: 5687
Re: Calculate Average in Rules
Well, A solution is to create two new columns. One will hold the initial value. The other One is a counter. In the Rule: You move value A to Hold_A, B to Hold_B etc. Then Conditional Statement: When Hold_A different from 0 then Counter_A=1 otherwise 0. Average calculation= For the consildation Only ...