I created rollup field in the portfolio to summarize time reported by the projects. Now I want to calculate the cost of the projects so I created formula field with this calculation:
300 * rollup (real time) / 60
where 300 is the cost per hour. I cannot change the format from time to currency. The field is grayed out.
Could you please advise what I should change in the field setup to unblock formatting?
PS. Similar formula on the project level allows me to change the formatting in this field.
It might be a limitation at the portfolio level where this feature hasnāt been unlocked yet. @Richard_Sather any idea?
There is this limitation on roll ups but Iām not sure if itās the case:
@AnnaPapiernik , can you share a screenshot please of the advanced formula and the Formatting tab also?
And I found today similar issue on the project level. Formatting was blocked, but I found the workaround:
Unfortunatelly on the portfolio level this woraround doesnāt work.
Hi @AnnaPapiernik , I now understand by āreal timeā you meant the āActual timeā field. Any time fields used will lock the formula. The key is to set the formatting BEFORE you Create the field. I think you should be able to create this in the formula of the portfolio level, as long as you try to recreate it but set the format before you create for the first time.
Let me know if you run into any problems.
@AnnaPapiernik
Adding to @Richard_Sather ās method, you need to add +0 at the end of your formula like 300*rollup(#actual time)/60+0. After that, you can chose the options in a formatting.
Good point, @Tetsuo_Kawakami , that I forgot, thanks!
It didnāt help 
I think you are right.
This combination helped:
Thank you very much for your help.
