내 커뮤니티 업적 표시줄을 확대합니다.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.
해결됨

My calculation field which is attached to Custom Form doesn't work

Avatar

Level 2

I have created calculation field, which is based on the data from two different fields (which are also included in the Custom Form) 

 

Formula

SUM({DE:Outcosts to date},{DE:Outcosts to complete})
 
Are attached the calculated field to one of the report and the report is attached to the project dashboard. 
The other fields are also attached to the report and to the different project dashboard. 
One I added value to both fields, the calculation field didn't summed up the numbers. 
 
Any idea what I done incorrect? 
 
Thanks in advance for your help 

 

1 채택된 해결책 개

Avatar

정확한 답변 작성자:
Level 2

Thank you Lars for your quick responds. 

 

I found the issue - I created a WIP Custom Form and added there the calculated field, then attached this field to the report and to the project dashboard. 

Because the Custom Form is not attached to the Project the calculated field will not work there. 

원본 게시물의 솔루션 보기

2 답변 개

Avatar

Level 10

Hello Mariola,

 

did you make sure, that the fields are formatted as numbers?

If not and the values are stored as a string, you could use the NUMBER() function to convert the strings to numbers.

 

SUM(NUMBER({DE:Outcosts to date}),NUMBER({DE:Outcosts to complete}))

 

Regards

Lars

Avatar

정확한 답변 작성자:
Level 2

Thank you Lars for your quick responds. 

 

I found the issue - I created a WIP Custom Form and added there the calculated field, then attached this field to the report and to the project dashboard. 

Because the Custom Form is not attached to the Project the calculated field will not work there.