Is there a way to calculate Row value with Column Value

[PrashaTwinkle]

Hi, Is there a way where I can multiply the row values with Column Value (no. of UVs) for the following table in the work space. 

For Eg., For row 1, I would like to calculate 1 * 121 = 121 , 2*28=56 ... and so on.

Thanks in Advance.

[bjoern__koth]

Hi @PrashaTwinkle 

that is not possible. The dimension values (rows) are considered to be strings and the metric values (columns) are th actual numbers. 
So, since these are different data types, it's not possible imho.

You can only create calculated metrics based on several column values only 

[MandyGeorge · Accepted solution]

There's no way to do this in workspace. Like @bjoern__koth said, one is a dimension, and the other is a metric. Dimensions are string values, so even if they are numbers, they aren't treated like numbers, they're treated like text.

If you use report builder though, this would be possible. Since the report builder is in Excel, you can build the table pulling data from Adobe directly in Excel and then have another column with a formula that multiplies the two values. Depending on what you're doing with the data, this might be a good alternative. 

[Jennifer_Dungan]

Yes, I second the Report Builder option if you need to use the value of the dimension as a number and not text... you will also likely have to use Excel formulas to convert the text to number.. I don't believe that you will be able to multiply it directly from the report builder data, as I believe it will be cast specifically as text... or it might work immediately.. I am not sure, I haven't specifically tried... but I know that with dates stored as text, I have had to add functions to cast as date.

[bjoern__koth]

Hi @PrashaTwinkle 

if you are using custom events for the column column values, you can alternatively also give these events a value that is set to the same as your dimension contains.

For instance:

• you want to track the dimension prop99 which contains the value "99" in your example
• your imaginary column metric could be event11 which normally would just be an increment of 1 every time the event is counted
• now, you could also assign your value of 99 to event11 instead

// directly
s.events = ",event11=99";

// or dynamically using the prop value
s.events = ",event11=" + s.prop99

this could also do the trick, with every occurrence of event11 it will be incremented in steps of 99 now