Formula based on a row

[bethgrap]

Is there a formula I could use to say: If Total CSG Sales for Programming does not equal Per P&L sales for Programming, allocate the total Per P&L sales to each state to equal Per P&L sales?

Thanks!

[RolandSchubert]

Hi @bethgrap ,

in my understanding, "Total CSG Sales" is the total of the states values above, right? I would split off the two total rows (text length > 2 could be used to select), calculate the relation between the values and multiply this relation with the state sales figures. I've attached a sample workflow. What do you think?

Best,

Roland

[bethgrap]

That works!

But now, how would you get the Total & P&L columns back to rows?

Thanks!

[RolandSchubert · Accepted solution]

I added the "re-union" part to the workflow, in addition to the allocated sales values, the "total" rows are at the bottom of the table. Hope this is helpful.