TM1 Forum

I put the S: because I want it to return a string but the if statement is looking at a number. thats another thing that confuses me. S: or nothing ? That's not a difficult question. If you write a rule for a String type cell, you must include the S: or TM1 will complain when you save the rules. Che...

Hi For one thing, TM1 uses ' where Excel uses " So make sure you got these right. If you don't have syntax errors but the result is incorrect, use the 'Trace calculation' functionality (right-click a cube cell in the cube viewer). Thanks Wim never used the Trace before. when I right click the ...

When you are writing string rules you have to use the full DB syntax on the right-hand side, not the short-hand [..] notation. Something like: ['All sources','Notes Source']=S:If(DB(CubeName, !Dim1, !Dim2,... !Dimx, 'source1')<>0,DB('fdi_cty',!FDI,!Direction,!FDI Composition,!Years,!Country,'Notes'...

Mark RMBC wrote: ↑Tue Mar 20, 2018 3:57 pm Hi Brad,

is this an order problem? Have you got ['All sources','Notes Source'] before ['All sources']?

cheers, Mark

Hi Mark
the element 'All sources' is before the 'Notes Source' in the dimension

['All sources','Notes Source']=If(['source1']<>0,"source1",If(['source2']<>0,"source2",ect.. This I would think is the simplest solution that if source1 isnt 0 then plug in the string "source1" but the sytax I used didnt work. so then I put the name ex. "source1&qu...

I have a cube with data from differnt sources. The "source" dim has 6 elements the 6th one is the allsources which I have a rule that ['All sources']=If(['source1']<>0,['source1'],If(['source2']<>0,['source2'],If(['source3']<>0,['source3'], ...],0)))); The code above works fine and populat...