Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Firmual to show figure if in sub group

Firmual to show figure if in sub group

Firmual to show figure if in sub group


We have a report that shows total volumes of products by sales rep and the Product group.

All furlmul's are set like the below

if {vwSalesOrderRepSummary_NoFilter.ParentID} = 2000
then {vwSalesOrderRepSummary_NoFilter.TotalVolume} else 0

This works fine, however, I have been asked to also display if the figures have a sub group of a certain type, one is 2070 and the other 2037. I tried adding the code as below and calling it test and adding it into the report but it just gives me 0.00 in the results. If I make the report look at a certain order number which I know as the productgroupid, it shows the right figure. So how do I get it to show the results when it runs for all orders. Any ideas please. Thanks in advance

if {vwSalesOrderRepSummary_NoFilter.ParentID} = 2000
And {vwSalesOrderRepSummary_NoFilter.ProductGroupID} = 2070
then {vwSalesOrderRepSummary_NoFilter.TotalVolume} else 0

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close