Summarize & Output Different Results

Question

Request: Need help with approach or design, see screen shots of workflow and sheet names = (Properties).

Each of these properties include similar column data but several have a different calculation.  Example: property 1 could be Rent = Rent + Storage, property 2 Rent = Rent + Storage + Parking, Property 3 Rent = Rent + Amenity Rent + Storage or Property 4 Rent = Rent

Workflow is built to bring in all the properties, generate all the columns currently; now just trying to figure out best approach to get each property output with the appropriate calculations without building a separate workflow.  Any suggestions welcome.

sslattery17 · Answer

@nagakavyasri  yes partially what I am looking for.  I already have my output file configured to output by property; but I also need to have a different calculations/summarization by property.

sslattery17 · Answer

@CoG

I have attached a zip file with dataset workflow etc...I currently do not have a table (key) that shows what each properties customization is; but could easily create one since the client sends us this data. (I attached a sample of what I was starting to create).

CR_DataScope_Charge Code Details - Sheet1.csv

CR_Sample DataSet Workflow.zip

nagakavyasri · Answer

@sslattery17 As per my understanding, I think you are looking to write output to multiple sheets. Consider the field which has the differentiating column and try this: