Reports and Revenue Balance

Hello, 

I am wondering which exact Revenue fields you are looking at. Technically, you can create a Custom Field that is based on a formula. Within the formula, you would calculate the fields as required to get the value you are looking for. This will allow you to then report on this custom field to show the data in Reports as desired.

For further clarification, we suggest you register for one of our Reports and Dashboards Training or Office Hours - Advanced Configuration Webinars (see the link-> http://www.clarizen.com/resources/online-demo.html#second ).These are free training sessions hosted by Clarizen Experts and offered weekly.

As mentioned I am looking at the Revenue Balance field which is a standard currency field and this is always a negative number which I would like to make a positive with using another calculated field. But I am not seeing what functions would allow this with a currency value

As mentioned I am looking at the Revenue Balance field which is a standard currency field and this is always a negative number which I would like to make a positive with using another calculated field. But I am not seeing what functions would allow this with a currency value

I see... I think I over thought this. This can be as simple as creating a Custom Field with the following settings...

Field Type = Currency

Formula = Checked/This Object

Set Formula = $RevenueBalance*(-1)

...dividing a negative value by -1 will give you the same value as a positive. Let me know if this requires further logic to meet your needs.

Well that's embarrassing, the formula could not be any more obvious. Thanks