PFA
To start with i did some division operation which is giving intended result but there were these greyed out values beside the resultant value in structure columns, which looks not so good for representation.
how to remove these greyed out values?
Hello @kallepallibharat krishna
The grey numbers appear by default when the 'Sum over sub-items' option is enabled in a column, and values are being aggregated. The grey numbers appear for parent items, and they indicate the parents' individual values. A grey number only is shown if the number itself is present either in a Jira field or in a column, on which the aggregation is based. I.e. in your case, it looks like you have actual zeros set in parent issues (as opposed to empty values), so they are being returned.
If you don't want to see the zeros, you need to remove them from parent items: if it's field: make it empty instead, if it's another Formula: return nothing if there is no value.
I hope this helps. If you need further assistance or if you have other questions about Structure, please reach out to us directly at our support portal.
Best regards,
Stepan
Tempo (the Structure app vendor)
In my case here those greyed out values are appearing after division operation ofcourse sum over sub-items option is enabled in the structure formula. Is there any other way to convert hours into days in structure? I am using division operation to convert hours into days i.e., round(tempo logged time/28800000) . Somehow this formula worked previously and greyed out values in columns were not shown.
Please suggest a formula to convert hours to days and without these greyed out values in the column.
Thanks
Krishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for sharing more details. We'll need to have a closer look at your setup and the used formula to be able to recommend specific changes. Please submit a ticket at our portal and we'll go from there.
Best regards,
Stepan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you please elaborate little bit as it will be helpful to understand? Are you using a plugin? What are you trying to achieve?
Best,
Fadoua
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Fadoua
Yes. We are using structure plugin on jira cloud. We have this tempo data of leaves for individual teams where they log their leaves against an issue. I just grouped one of that issue in structure based on 'tempo contributors : logged' and trying to convert the tempo logged hours by individuals into days by division operation i.e., hours divided by milliseconds - for converting hours into days which is giving the intended result but greyed out zeros were shown beside the results in the structure columns. What can i do to hide these greyed out zeros in the columns? Do i need to use any function in the formula to not show these greyed out values in the columns? Previously round() function worked to remove these greyed out values in the columns but it is not working now i think.
Thanks
Krishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for the details! I see that @Stepan Kholodov _Tempo_ from the right team is helping. Wishing you best of luck resolving the problem you are having.
Best,
Fadoua
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.