Hello Everybody,
I am facing any issue with SUMIF function in one of my reports. The function is working properly in PAx where as it is throwing #ERR! while opening on TM1 web. I tried several posts/blogs to get the solution for this issue unfortunately I couldn't able to find the reasonable answer.
Below is the recommendation from IBM.
Upgrade to TM1 10.2.2 FP1
Let me know if anyone have any inputs on the above issue.
Thanks,
Hemanth
SUMIF results in #ERR! on TM1 web
-
- Community Contributor
- Posts: 292
- Joined: Tue Sep 06, 2016 7:55 am
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: Excel 2010
Re: SUMIF results in #ERR! on TM1 web
As you say it looks like a known fault.
Never used PAx but whenever I have used Sumif in TM1web I can only get it to provide a correct value if I reference the exact range, so A1:A5 and not columns, so A:A
Probably not going to help you in this case but that is my input!
Never used PAx but whenever I have used Sumif in TM1web I can only get it to provide a correct value if I reference the exact range, so A1:A5 and not columns, so A:A
Probably not going to help you in this case but that is my input!
-
- Posts: 21
- Joined: Thu Mar 28, 2013 10:12 am
- OLAP Product: IBM Planning Analytics
- Version: 2.0.93
- Excel Version: 2 0 94 7
- Location: Paris, France
- Contact:
Re: SUMIF results in #ERR! on TM1 web
Hi,
I had the same problem,
the solution will be to put the sum.if at the end of the DBRW, because the systme execute the first line before the reste, so for that you will have #Err,
best regards,
Zied
I had the same problem,
the solution will be to put the sum.if at the end of the DBRW, because the systme execute the first line before the reste, so for that you will have #Err,
best regards,
Zied