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.
Hi @SouravKayal -
Could you please provide an example of the desired output?
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