Calculated Field Showing as Negative Value

(0) Share

Report

Posted on by Harry Stover

Hello there,

I've just created a calculated field which will count days that an Opportunity record is active. This field is called Lifespan. So each day the value should grow +1.

The behaviour is set as below. This somewhat works as each day the value changes, however the value is decreasing. ie. The day its created the value is 0, the next day is -1, then -2 etc.

I'd like this field to increase daily rather than decrease. I tried changing the order of the the Action to DIFFINDAYS(createdon,NOW()), but this gives an error due to the data types. Would appreciate any advice on this.

Thanks,

Harry

All responses (2)

Answers (1)

Suggested answer

Harry Stover 10 on at

Like (1)

Report

RE: Calculated Field Showing as Negative Value

Hi Pradeep,

Thanks for this. I was attempting this yesterday and was getting an error due to the data types. It seems to be working as intended now.

Thank you very much for the speedy response!

Harry
Verified answer

Pradeep Rai 5,490 Super User 2024 Season 2 on at

Like (1)

Report

RE: Calculated Field Showing as Negative Value

Hi Harry,

I tried with below condition and it is working for me.

Output: