Hi Anyone knows how to show 0 for 0 value and blank for empty dates in Dynamic table? [image] [image] Thanks, YY

A solution is to send a string: '0'. Not very clean but it should work. The same for empty dates: ''.

Hi @YY1 ! Could you show a sample of the data you use? It will be easier to reproduce your problem. Regards, Bertrand

Hi @BertrandDrouhard1 Thanks for your help. [image] The data exported are correct. Please use spreadsheet or Excel to open it becaus it’s a CSV file: sprintdata_2024-03-08T13-16-06.docx (2.0 KB) The app is under development enviroment. I think we can install it to triage the issue if you need …

I can’t open your docx file, the format is invalid. Maybe you could just share the csv content in a post in a code section.

boardName,boardLink,sprintName,sprintLink,sprintGoal,sprintStatus,completionRate,committedStoryPoints,completedStoryPoints,timeProgress,timeEstimate,timeSpent,toDoIssuesCount,inProgressIssuesCount,doneIssuesCount,startDate,endDate,completeDate IPD Scrum Board,https://hangzhouace.atlassian.net/jira/s…

In my DynanicTable, if the content value of a cell is null, then it works as expected and displays nothing (and not a 0). Maybe in your code the null values from a csv are changed by mistake into a 0.

[image] BertrandDrouhard1: are The csv file are data returned from backend and you can see completedStoryPoints is 0. The front end code is: { key: sprint.completedStoryPoints, content: <Inline alignInline="center">{sprint.completedStoryPoints || 0}</I…

I changed it to hard code { key: sprint.completedStoryPoints, content: 0, } the result is: all blank [image]

Usually what I do in such situations, is to test with static data, to make sure that the bugs really comes from my side. I also confirm that the sorting feature of DynamicTable does not work (sorting is done one the last column in my case).

I think that the key must be unique for a cell. Try to add an id to sprint.completedStoryPoints. Good luck!

If I changed 0 to 1 as hard code, the result is correct： [image]

The Atlassian Developer Community

Dynamic table order incorrectly for decimal points columns

Forge Forge UI Kit and Custom UI

YY1 March 8, 2024, 2:44pm 13

Thanks for your help @BertrandDrouhard1