rounding negative values

Question

I need help with a calculation, and I'm sure I'm missing something obvious.

I have a calculated field to determine the difference between a custom date field and the project planned completion date:

WEEKDAYDIFF({plannedCompletionDate}, (ADDWEEKDAYS({DE:First Offer Date},-15))).

I included the field in a report and added conditional formatting for it (>=0 [Green]; >=-5 [Yellow]; <-5 [Red]). This works fine.

Then I wanted to try to account for holiday exceptions in our schedule. I added a calculated column in the report (I wanted to try it out here before changing my calculated field):

valueexpression=ROUND(WORKMINUTESDIFF({plannedCompletionDate}, (ADDWEEKDAYS({DE:First Offer Date},-15)))/480).

The underlying calculation works; however, rounding the calculation results in positive values. How can I round the result and still maintain any negative values?

Thanks.

skyehansen · Accepted Answer

Unless I miss my guess, "workminutesdiff" will never give you a negative result. If you want to use it, my guess is that you should find some way to artificially place one outside of the workminutes part of the equation (i.e. if first offer date minus 15 is > planned completion date, "-", then the workminutes calculation).

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded