TM1 Forum

thanks for your help steve.. I implemented the changes and now is working. This is the final code: ['1_Entry Price']= N: IF( DB('Fund Accounting Daily',!Portfolio Code,DIMNM('Reporting Period Daily',DIMIX('Reporting Period Daily', !Reporting Period Daily)),'Entry Price')=0 & DB('Fund Accounting ...

Wim Gielis wrote:It would help if you post your actual feeders and show us what you tried.

This is my last try

You just need to replicate your conditionality in the feeder as well. You need to feed from today to tomorrow for the cases where these if no input, but watch out for breaking the feeder stack. Suggest you review the various threads on the feeder stack and long chains of feeders. I'd also suggest t...

Hi Guys, I recently developed a rule that use an IF statement. But the values are not adding up into the consolidation. The rule check if for every day ( Reporting Period Daily dimension), the value is 0 or <>0 in the dimension ( FA Measures dimension) for an element called "Entry Price" ....

Hi All, Thanks for your help, really need to figure out this issue with TM1 2.png 1.png 3.png as you can see in both pictures.. I'm applying a rule for C: and N: level that shouldn't affect each other..but somehow they do it... but if I change the order or comment out the lines the results change to...