Numbers are not always displayed as Positive.

Gridview displays positive numbers and negative numbers differently.

999.99 is positive; (999.99) is negative.

In the formula

IF({Doc Type}="C",-{Total Dollar Value}*{% Comm}/100, {Total Dollar Value}*{% Comm}/100)

it is the -{Total Dollar Value} that makes the Commission negative.

Hi Michael:

I understand that, but that's not what I see happening. Please look at the attached screenshot. You'll see 3 credit notes. Under both 'Total Dollar Value' and 'Total Order Value' you'll see positive amounts. I had to create a calculated column called 'True Amount' that would convert those amounts that were credit notes into negative amounts.

Cheers,

Andre

I meant 'Total Dollar Value' only. The amounts in 'Total Order Value' for credit notes appears to always be zero.

Andre:

Yes, "Total Dollar Value" will always be positive. You need to look at the type of Document and reverse the sign if it is a Credit Note.

That is what Michael's formula does. If the Document is "C", then switch the sign. And this is exactly what you did with your "True Amount" calculated column.

I believe that you and Michael are in agreement, just expressing yourselves differently.

The only question is why you weren't able to use your "True Amount" column to calculate your commission amount. As David said earlier, that will work. For instance: {True Amount} * .10 will give you proper figures.

Of course, since you have a calculation that works, why change it?

Hi Bruce:

Yes, now that it's working, I'm not going to change it.;-)

By the way, I recreated this report using the Sales Order Detail table (We had to exclude miscellaneous charges - and those are not in the header table). I used pretty much the same formula ('Amt' instead of 'Total Dollar Value') - and everything worked like a charm. And the user I wrote this for seems to like the result.:-)

Thanks all for your help!

Andre

Andre,

I am not familiar with the programming language used for Adagio modules, but there is one general underlying reason why the number may always be stored as positive ones: you can store larger numbers.

A small example:

In one byte, 8 bits, you can store values up to 2 to the 8th power, 256.

But, if you take away one bit to store the sign, you can then store values from -128 to +128.

The same is true, of course, for multi-byte integers as well.

Just a thought: I'm sure Adagio's programmers did not set it up that way just to annoy you and me .