Columns in report not available in custom calculation

  • 2
  • Problem
  • Updated 3 years ago
  • In Progress
  • (Edited)
I have added the following columns:

  • Not Submitted Billing Amount (Selected Dates)  
  • Not Approved Billing Amount (Selected Dates)   
to my project report however when I generate a custom calculation to total the two together they are not selectable as titles to be added.
I have used the same custom calculation already for the Not Submitted hours and not Approved hours and it works fine.
Can the billing fields be added as available fields for custom formula's?
Thanks
Photo of Hines, Paula

Hines, Paula

  • 2 Posts
  • 0 Reply Likes

Posted 3 years ago

  • 2
Photo of Lingaraj Dharwad

Lingaraj Dharwad, Product Champion

  • 1100 Posts
  • 46 Reply Likes
Hi Paula,

Welcome to Replicon Community!

Thank you for reporting this issue, we are looking into this and will update this thread by EOD today. 

Regards,
Lingaraj
Photo of Lingaraj Dharwad

Lingaraj Dharwad, Product Champion

  • 1100 Posts
  • 46 Reply Likes
Hi Paula,

Just to give you an update on this, we are escalating this to our engineering team and will update this thread once we hear back from them. 

Thanks,
Lingaraj
Photo of Timmons, Jeff

Timmons, Jeff

  • 1 Post
  • 0 Reply Likes

I believe my question is similar (or identical).   I have a custom column on a report that appears fine.  I am now attempting to create another custom column for the report which relies upon the first custom column.  Is this even possible?  If so, does the order they appear on the report have any impact on the result of the custom column computations?


Photo of Aashnee Kamboj

Aashnee Kamboj, Community Moderator

  • 1557 Posts
  • 108 Reply Likes
Hi Jeff,

Thank you for using Replicon Community and apologies for a delayed response.

You will not see the previous custom column name appearing for selection while creating a new custom column. However, what you can do is use the exact formula embedded in the first custom column in the second one. 

To answer your second question the order they appear on the report have no impact on the result of the custom column computations.

I hope I answered your question.

Thanks,
Aashnee