Hello.
I'm dealing with multiple if then statements that could be dealing with a subtraction between 2 negative numbers but it appears once it meets the first statement it skips the rest. Thanks for any help
Here is how the report is looking.

Variance   Change   Variance Prior
($6)           $19           ($13)   <-- should be ($19)
$100          $200          $300
($2487)      $7461      ($4974) <-- should be negative


Here is the formula i'm using

if {@Variance} < 0 and  {@Variance Prior} < 0
then
({@Variance Prior} * (-1)) - ({@Variance} * (-1)) *-1
else
if {@Variance} < 0 then
{@Variance Prior}- ({@Variance} * (-1))
else
if {@Variance Prior} < 0 then
{@Variance} - ({@Variance Prior} * (-1))
else
{@Variance} - {@Variance Prior}

Thanks for the reply DBlank

These are group summary values.

Both are calculation based off another fields in the report.

A-B = Variance
Same for prior just in a sub report.