Skip to Content
author's profile photo Former Member
Former Member

EVDRE different send members than get members

BPC 7.5 MS SP3

Parent Accounts > RT_R RT_R BAS Accounts> 1B 1B

Parent Routes Parent Employee GET Only Range Bas Routes Bas Employee

RTE_105_31 HRGK 7,871 7,559 RTE_105_31 E125634 $6.50 $7.80

RTE_105_33 HRGK 8,156 7,979 RTE_105_33 E562158 $15.80 $20.00

RTE_105_35 HRGK 9,742 9,810 RTE_105_35 E632589 $32.00 $55.60

I have an EVDRE where I want to GET data on the left from parent levels, run some calculations in excel and send the data to the bas members on the right. can that be done with one EVDRE formula? Leaning torwards staying with EVGTS & EVSND's at this point.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 09, 2010 at 02:07 PM

    Hi Matthew,

    You can achieve this by using multiple EVDRE's in the same schedule.

    For example

    A               B        J       K             L
    EVDRE1                     EVDRE2
             COL1                               COL1
    PARENTA  10              PARENTA CHILD1     =lookup value in column J using column A and some formula eg EVPRO(child1)
    PARENTB  10              PARENTA CHILD2     =lookup value in column J using column A and some formula eg EVPRO(child2)
                             PARENTB CHILD1    ...
                             PARENTB CHILD2
    
    

    Hope this helps,

    Madis

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.