Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

How does "Calculate percentages by row" work?

Avatar

Level 8

Hi there,

 

I think I must be missing something but how does "Calculate percentages by row" work? In the table below the logic seems fine for columns (total percentage = 300):

 

Column.PNG

 

However when you switch this to Rows I am shown:

 

row.PNG

 

Which does not total 300% but rather 126.6%.

Thanks


Dave

1 Accepted Solution

Avatar

Correct answer by
Community Advisor
4 Replies

Avatar

Correct answer by
Community Advisor

Avatar

Level 8

Hi there, that video shows it working exactly how I would expect it to work, however as you can see from my screenshot, my work space is not totally 100% per row.

Avatar

Community Advisor

Hi, I think that's cause you may not be using all variable values captured in "*_check" on orders event. Ex. if variable product has four variants (a, b, c, d) captured on order (one unit in each value) and you only arrange 3 variants (a, b, and c) it will show row total only 75% due to missing variant d having rest of the 25%.

Avatar

Level 8
Hi asheeshp - that is correct! Not sure if that should be called a bug or a feature