SumOf expression / Labels

[BroncoMarc]

I've got a pretty simple query that's giving me trouble. Attached is a picture of it:

Basically I have 2 columns that are Sums. The 3rd column is an expression that divides one sum by the other. It was working fine until I went back and added labels to the first 2 columns (Sales and Price in the picture). Now suddenly it doesn't know what SumOfExtendedNetPriceUSD and SumOfBillingQuantity are and it prompts me for their values when I run the query.

Any help would be appreciated.

- Marc

 

[pono1]

Marc,

Maybe something like this...

Sales: [BillingQuantity]
Price: [ExtendedNetPriceUSD]
Unit Price:[Price]/[Sales]

Regards,
Tim

 

[BroncoMarc]

I swear that was the first thing I tried and it didn't work! But I tried again and looks like that does it.

Thanks,
- Marc