SELECT - two attributes

samdal
samdal
in Modeling

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
    Misbah
    Answer ✓

    @samdal

    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

    Thanks,

    Misbah

    Miz Logix

  • samdal
    samdal
    Answer ✓

    Thanks!

Answers

  • andrewtye
    andrewtye

    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.

Categories