Joining Data sets

[SouravKayal]

Hi Team,

I have a data set as below

Cost ID  Jan$ Feb$

123        100    200

123        200  300

Cost ID splits1 splits2 jan % Feb $

123      A         A1         25        25

123      A         A2          25        25

123      A         A3          40         25

123     B          B1          10         25

I need to split the % based on the % as above and bring in the splits. When i tried to join and then put a formula to calculate by multiplying with the % the data is increasing.

[kelsey_kincaid]

Hi @SouravKayal -

Could you please provide an example of the desired output?

[SouravKayal]

HI ,

so it should be 

Cost ID Splits 1 splits 2 jan$ feb$

123       A            A1          75   125

123       A            A2         75     125

123      A             A3          120   125

123     B              B1           30    125

So totals should be the same , only the $ will get split row wise based on the %ages