help required

[Rajsekhar8917]

Hi 

I would request you to kindly help me in building a workflow

Hi all I would request you to kindly help me in building a workflow

. The problem is attached in excel format and output is also mentioned with calculated logic  I want help in building a workflow dynamic  Thanks in advancee..!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Input table

Product   divide.     Jan.   Feb.   Mar.   

A.                 2.             1.       2.       4

B.                  3.              5.      6.        7

Divide the corresponding month sales with divide number

Process

Product.   Jan.       Feb.              Mar  

A.                1/2.     

    A.                 1/2.       2/2-1/2.  

A.                  1/2.      2/2-1/2.     4/2-(2/2-1/2)

B.                   5/3 B.                    5/3.       6/3-5/3.

B.                  5/3.       6/3-5/3.      7/3-(6/3-5/3)

Output Product.     Jan.     Feb.      Mar.   

A.                  1/2.      2/2-1/2.     4/2-(2/2-1/2)

B.                  5/3.       6/3-5/3.      7/3-(6/3-5/3)

.

[cplewis90 · Accepted solution]

Hello @Rajsekhar8917,

See if the attached workflow helps achieve your solution needed. 

[Rajsekhar8917]

Hey 

 thanks for responding 

[cplewis90 · Accepted solution]

No worries. I thought you wanted the solution to look as you presented the information.

Made some minor adjustments to the data types. Find the attached solution.

[Rajsekhar8917]

Thanks @cplewis90 

[danilang]

Hi @cplewis90, @Rajsekhar8917  

How did you come up with a solution without any info on the Problem?  

Dan

[cplewis90]

Hey @danilang,

It looks like there might have been an edit to the original post. There was data when I first looked at the problem. @Rajsekhar8917 did your post change from the original? I remember there being data in the original post with a start and end point sample of data.