Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Bradford847

    Move variable from report into email title

    Hi Deb, Can you just elaborate a little on this please. I am trying to do a similar thing but I'm not sure what you mean by passing the variable into the alert message. How do I get the alert message into an e-mail? All I'm trying to do is send an e-mail (with no attached report) of who has...
  2. Bradford847

    Manual median calculation ignoring zero's

    Thanks LB. That's very neat logic. I've just tried it and I get an error message in the first formula, {@Val1}. It doesn't like using the TONUMBER command to convert the empty formula, which it thinks is a string, to a blank. Can you think of any way around this? I'm using CR 2008 by the way...
  3. Bradford847

    Manual median calculation ignoring zero's

    Thanks Ian. I'll give that a try as we don't have that many customers in any particular country so may not be too slow. It will probably be easier than using an array!
  4. Bradford847

    Manual median calculation ignoring zero's

    Is there a way (I was thinking arrays possibly) that I can manually calculate the median for a group so that it can be used in the conditional highlighter? I am trying to add conditional highlighting (traffic lights basically) to some values based on how far away they are, in percentage terms...

Part and Inventory Search

Back
Top