TM1 Forum

Anoop, it's not clear from your post if you're doing this in TM1 or TM1 Web. For TM1, create a new measure that multiplies your two other measures (via rule) and use a consolidation to sum. In TM1 Web (Excel), create a hidden column that multiplies the two values and sum that column. Matt ;) So cut...

Dear everybody

how does tm1 can implete triangle fuction caculation like excel SUMPRODUCT fuction ? ? ?


thx.

['Net-Turnover']=N:DB('CT_P&L',!Internal_External Budget,!organization,!Versions,'IAS €',!Years,!Months,'Net-Turnover'); ['Operating Income']=N:DB('CT_P&L',!Internal_External Budget,!organization,!Versions,'IAS €',!Years,!Months,'Operating Income IAS'); ['Steuersatz HBI']=DB('CT_Premises',!I...

Hello Martin thanks for your so nice interpret, yeap, below two snapshts are from cube A that all data come from cube B by rules, B also have same dimension with Actual and MR2+10…… members, for cube B, all actual data come from bussiness data by input by me( for testing ), then I change the member ...

Thanks for so more reponses for me. sorry for offered less information, now I try to upload two pictures, wish that can help you know my issue, in fact all data of pic MR2+10 come from by rules [{'MR_1+11','MR_2+10', 'MR_3+9','MR_4+8','MR_5+7','MR_6+6','MR_7+5','MR_8+4','MR_9+3','MR_10+2','MR_11+1',...

Dear all.

I am new comer for TM1 product. now find a very odd issue, that the data of grid will have little change when I changed the dimension member from one to another, in fact that the second data quote from the first data . ???

wish get your kindly response. thx.