
1. Re: How to make a calculation result default to zero if negative?
KylePutzier Nov 8, 2012 10:54 AM (in response to dustyhanes)= Max(YourCalcResult;0)
Kyle

2. Re: How to make a calculation result default to zero if negative?
dustyhanes Nov 8, 2012 12:17 PM (in response to KylePutzier)Kyle,
I tried the Max calculation, and while it does prevent the result from being negative and shows it as 0, it still stores the original result and treats further calculations as if it were the negative number. Like the scenario I layed out in my OP, the net result would be the 75 instead of the more accurate 100.
Is there a way around this? Thanks so much.

3. Re: How to make a calculation result default to zero if negative?
KylePutzier Nov 8, 2012 12:32 PM (in response to dustyhanes)You would use the result of the Max() function in your downstream calculations.
Kyle

4. Re: How to make a calculation result default to zero if negative?
PalmDBS Nov 8, 2012 2:21 PM (in response to dustyhanes)Assign the calculated value using a Let statement along with Kyle's Max statement. Your result would be either 0 or a positive number.
Let(
[
MyCalcResult = my calculations
];
Max(MyCalcResult;0)
)
or, put your calculations all inline with the Max function, and simply define your field as a calc of
Max(My Calculations;0)

5. Re: How to make a calculation result default to zero if negative?
flusheddata Nov 13, 2012 3:06 PM (in response to dustyhanes)If ( Sign ( YourCalcResult ) = 1 ; 0 ; YourCalcResult )