Show Negative Time

[gmazza76]

Good morning,

I am new to Power Pivot and could do with some help please.

I have 2 columns (Requested & Actual) showing time and I need to confirm if we are above or below the actual requested time allowance.

I want to show if the Actual is lower than the Requested in a time value.

I am using the formula below, but the calculation always shows the value but not in a negative (-) value if the Actual is less than the Requested

='Tablename'[Actual]-'Tablename'[Requested]

Sorry if this is a simple question
thanks in advance.
Gavin

 

[rondeondo]

Hi Gavin
what display format do you have set for your calculated value? what does it show, please provide example of the output

you could also wrap your calculation in an if
for example:

=if('Tablename'[Actual] < 'Tablename'[Requested], "Text to denote better than requested" , "Text to denote after requested") & 
'Tablename'[Actual]-'Tablename'[Requested]