We have a Financial report , designed with the help of FR studio. One of Columns of this FR is named "Affiliate Id " Which is pulling a unique ID for different companies. These Affiliate Ids are being pulled out from a data form where the entries are being submitted with the help of Smartview / Workspace.
Now the issue is that when FR is Run then the Affiliate Ids are Displayed in the following form: i mean the numeric values are being displayed Upto 6 decimal Places which is not the Way its should be and we want it to be without any decimal value as they are submitte in data form without any decimal value.Irony is that in the same FR we are getting the values in one another column(Governmenr Id) in proper way( Shown Below )
|Aff ID Undefined|
In both The Columns, Values are being pulled as celltext and formulaes being used are:
For Affiliate ID:
<<CellText("Grid1", Cur, C(A), 1)>>
For Government ReportID:
<<CellText("Grid1", Cur, D(B), 1)>>
So Please help in knowing that what may be the possible cause of Affiliated ID being deisplayed with such huge decimal values how i can correct that, through FR studio or from workspace/ Data form from where it is being pulled.
Note:Even if we See the Affiliated ID in data form after submitting and refreshing, its picking decimal places there also same way.
Questions? Are you talking about the text values pulled using CellText or the real numbers from Planning.
If it the CellText then check that intersection, User might have entered a note with decimals in it. FR won't generate decimals for text.
If you are talking about the numbers then you'll have to look in Planning how it is entered and how decimals in FR is setup.
I have observed few more things and updating here the same.
Firstly the we are working on HFM, Not on planning.
2ndly, we checked the data form(from where the affiliate ID Column is being populated in FR) thorughlly. we found that when we are submitting data in data form through smartview ,that data is being displayed in data form on workspace as value upto 6 decimal places. like if we submit 1234 in a particular intersection of data form through smartview and when we view that in Data form in workspace, That is being Displayed as 1234.000000.
Ironically, the Same Value when submitted in data form through Workspace, It is being displayed without any decimal i.e. it will be 1234 only.
So Issue is specifically related to submission through Smartview in data form. Help me understand that what approach should i follow now to fix it.
Thanks in advance,
I am a bit confused... because initially you say cell text and then in the second post you discuss about data. I believe that you submit a cell text and not data. Do you get the same error when you submit non-numerical characters? Maybe a workaround will be to type a non-numerical character
Which version are you working on?
Sorry for the confusion.
Yes We are submitting cell text.
For non-numeric data, we dont have any issue. Like if we submit "Aff ID Undefined",then its been shown in FR without any issue.
But When any numeric value is pulled in FR, that comes with 6 decimal places like 1234 shows as 1234.000000. You can see the below pattern(directly copied from FR)
|Aff ID Undefined|
Note: Issue is specifically with the Cell text submitted in data form through smartview/Excel. If we submit thorugh workspace, then we dont face this issue.
I hope it helps you understand the whole aspect.