Copying Same Data Line Item to other Formulated Line Item

aishabhy05
Contributor

Copying Same Data Line Item to other Formulated Line Item

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

1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

Re: Copying Same Data Line Item to other Formulated Line Item

@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


Jared Dolich

View solution in original post

2 REPLIES 2
JaredDolich
Moderator

Re: Copying Same Data Line Item to other Formulated Line Item

@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


Jared Dolich

View solution in original post

aishabhy05
Contributor

Re: Copying Same Data Line Item to other Formulated Line Item

@JaredDolich  awesome!! This helps. Thanks 🙂