TM1 Forum

I need to write a rule as follows:
value,company 1 = value, company 2 or 3 or 4 .... whichever is NOT zero.

Can it be done?
Thanks

I think you can use nested if statements in your rule.

You could always use a consolidation to do it? You could also use TI to copy the data (use a relevant view as the source) if you don't need a real time relationship,

Jim.

mnasra wrote:I need to write a rule as follows:
value,company 1 = value, company 2 or 3 or 4 .... whichever is NOT zero.

Can it be done?
Thanks

Jim's suggestion is a good option: have a consolidated element, f.i. 'Other companies', summing up Company 2, 3, 4, ... (but not Company 1) and have a rule like:
['value', 'Company 1'] = N: ['value', 'Other Companies'];

Depending on the specifics of your model another option could be to make Company 1 a consolidated element, summing up Company 2, 3, 4. In this case you don't need any rule.

Michel

Thank you all- Unfortunately none of the suggestions helps 100%
1- The nested ifs are out of the question, because I have toooooo many companies and I dont know if some are going to be added in the future
2- TI is not an option, it should be live data
3- Cie 1 = Conso of all others is not an option, because cie 1 could have its own value
4- The only option I am going to explore is try to create consolidations of all other companies- Unfortunately, I am not sure that ONLY ONE of them will be different than zero- But I will definitly explore this.

By the way, I tried to see if the {cie2, cie3, cie4} work but it gives me syntax error.
THANK YOU ALL- If I cannot do it with option 4, I will have to rethink my dimensions.

I see you're on 9.5. Any chance of upgrading to 9.5.2? The new ConsolidatedMax function might help you.

WOW- Thank you Martin,

I had seen the CONSOLIDATEDMAX very quickly and thought, and I will use it one day-
Yes, definitly this would work.
Thanks again