Sort Expression

[alnilla]

Hi guys,

I have an expression that is

contribmargin: [totalmoneycontrib]/[totalreveune]

Now when that comes out its a percent

What I want to do is sort it by anything less then 60 percent i want to show up.

when i run the qry in designview I get a pop up for totalmoneycontrib and totalreveune


Im sure its an easy fix im just missing something.

Thank you

 

[plog]

First, that does not produce a percent, it produces a decimal. A technicality, but this is a technical issue.

Second, if you are getting a message box asking for what they are, then those fields do not exist in the underlying data source of your query. My guess is you are calculating them in the same query you want to use them in. This leaves you two options, either delete contribmargin from that query, save it and create another query based on it where you can do your contribmargin calculation. Or reconfigure your contribmargin contribution to use the underlying sources that you use to calculate the two fields that make up contribmargin.

 

[alnilla]

This expression is using two other expressions to get that decimal. That is the issue then? So in order to sort it by that I have to use the field and tables to sort it correct?