Page 1 of 1
TM1 Web negative number didnot allowed
Posted: Wed Dec 15, 2021 2:41 pm
by mincharug.shulft
TM1 web report is not allowing to enter the negative number. while we/user tried entering the negative numbers in TM1 Web for certain intersection then it is popup the error. the error is "incorrect dollars for the resource type". but if I go to cube viewer in the same combination then input number then I am able to enter the data. Any suggestions pls why I am getting the error?
we are using PA Local 2.0.3 version.
Re: TM1 Web negative number didnot allowed
Posted: Wed Dec 15, 2021 3:40 pm
by lotsaram
What number format is being used for the display and for the input?
Re: TM1 Web negative number didnot allowed
Posted: Wed Dec 15, 2021 4:04 pm
by PowerDim
Is the report made on the basis of a websheet (on Excel by TM1 Perspectives) or a simple view?
If it is a websheet, then it looks like a format problem on the Excel side.
If a view, then this is a strange situation. Maybe clean broweser's cache?
Re: TM1 Web negative number didnot allowed
Posted: Wed Dec 15, 2021 4:10 pm
by mincharug.shulft
HI lotsaram, There is no number format set it in the measure
Re: TM1 Web negative number didnot allowed
Posted: Wed Dec 15, 2021 4:12 pm
by mincharug.shulft
Hi PowerDim, it is an active form report developed using perspectives. and published to the TM1 web. Excel format how to check that?
note: I am able to enter the negative number in the tm1 view but in the same combination in the tm1 web report I am not able to enter throwing an error.
Re: TM1 Web negative number didnot allowed
Posted: Wed Dec 15, 2021 5:31 pm
by PowerDim
You need to check a format cell in a hidden area in your active form for the row you want to write values to.
Check the link for finding hidden area:
https://www.ibm.com/docs/en/planning-an ... nge_N80346
Re: TM1 Web negative number didnot allowed
Posted: Wed Dec 15, 2021 6:35 pm
by mincharug.shulft
Hi PowerDim, I have checked the format of the report. it is set to N for granular level elements (input elements). but the interesting part is I am able to input the negative numbers in the cube viewer but not able to input in the web. Any other thoughts pls?
Re: TM1 Web negative number didnot allowed
Posted: Wed Dec 15, 2021 11:23 pm
by burnstripe
How old is the report, has it just been created? If not try creating a new spreadsheet with a basic active form and uploading, is the result the same? Or better still have one dbrw formula pointing and see if that works.
Either way it should point you in the right direction to fixing the problem.
Also do all users experience the same issue and do the symptoms occur over different types of browsers?
I'm wondering if there's a data validation set within the format area of the active form (for n if that's what the row is using) that rejects it if the value is negative. It doesn't look like a typical error message but custom made.