TM1 Forum

Hi thanks for your replies Consider the first column as the list of sales staff with their accounts they own. The second column is the total sales revenue for october. (obtained from the sales cube based on all the sales for that account for october) The third column is the total sales revenue for t...

All I would like to be able to have formulas applied to child elements in an excel active form or even a rule. I have tried formula just to count total child elements and dont even get that right ['Count']=N:IF(['revenue']>0,1,STET); from another post gives me large numbers due to multiple sales tra...