Copying Same Data Line Item to other Formulated Line Item

Options
aishabhy05
aishabhy05
in Modeling

Dear All,

 

I have a scenario as follows :

 

I have a Module with SKU, Company as dimensions. Sales Volume is an input. 

aishabhy05_2-1625881735811.png

List Items in Company are GST, TMB, BCC. 

Now, I want the data in line items to be copied to the company as follows: 

aishabhy05_1-1625881632607.png

The output module should contain the input value as well as the copied data value.

 

Thanks,

Aish

Tagged:

Best Answer

  • JaredDolich
    JaredDolich
    Answer ✓
    Options

    @aishabhy05 

    Wow! That was really fun! Another! Another!

    Steps to recreate your scenario:

    • Create Booleans to determine if country is editable / not editable - Use DCA! - only country/sku combinations that are valid should be editable
    • Create Boolean values for conditional formatting 
    • Create Line item to capture copy rules - select the country to copy from
    • Calculate Sales

    CopyCountry01.pngCopyCountry02.pngCopyCountry03.png

Answers

Categories