SUMIF results in #ERR! on TM1 web

[hemheman]

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

[Mark RMBC]

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!

[zbhmida]

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