SELECT - two attributes

I try to write a function that selects both a specific version and a specific level in the hierarchy from a list. I know how to use the SELECT function individually on each of those selections: 1) Sales module.Gross sales [SELECT: VERSIONS.Actual] and 2) Sales module.Gross sales [SELECT:Product.Nuts]. How do I write the formula to combine those two selects?

Best Answers

  • Misbah
    Answer ✓


    Sales module.Gross sales[SELECT: Versions.Actual, SELECT: Product.Nuts]

    Note that if Product list is a Production data, you may need to use LOOKUP instead



    Miz Logix

  • samdal
    Answer ✓



  • And of course if you are using a Lookup then would have that as two separate line items. One for the select and then one doing the lookup.