I am trying to calculate a profit margin by using the formula as follows:

({@Pmt} - {@ExtendedCost}) / {@Pmt}

This was giving me a division by zero error, so I tried implementing this change:

If {@Pmt} <> 0 then
({@Pmt} - {@ExtendedCost}) / {@Pmt}

The error is gone, but it gives the result of 0 for all calculations when the formula results from both @Pmt and @ExtendedCost are both non-zero values.

I'm stuck and would appreciate any help you all can offer.

I hadn't, but have now to no avail. Have tried:

If {@Pmt} = 0 then 0
else
{@Pmt} / {@ExtendedCost}

If {@Pmt} > 0 then 0
else
{@Pmt} / {@ExtendedCost}

If {@Pmt} < 0 then 0
else
{@Pmt} / {@ExtendedCost}

All of which will return the division by zero error depending on which page of results in the report I am on.

you could try to
in select expert put
{@Pmt} <> 0
or
If {@Pmt} = 0 then
({@Pmt} - {@ExtendedCost}) * {@Pmt} else
({@Pmt} - {@ExtendedCost}) / {@Pmt}