nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Conversion to find the resultant effort

Ramu_kd54ib

Hey,

I have a scenario/Confluence Table as follows:

The ask is -> I'm using a Table Transform SQL code to display these values (simple straight forward Table) .. however, the need is to display the remaining effort ..

i.e., .. for 10 Story points, if the overall progress is 50% then i need to display another column 'Remaining effort' as either 50% or 5 Story points ..

i have tried converting the percentage(overall progress) into number OR number(story points) into percentage and then tried subtracting one from another ...

BUT,

logically this is not helping ..coz it is not a direct subtraction as in i cant simply convert

50% to 0.5 and then subtract it from 10 Story points coz the result will be then 9.5 which is incorrect for my ask ..

i.e., .. for 15 Story points, if the overall progress is 90% then i need to display another column 'Remaining effort' as either 10% or 1.5 Story points ..