Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Advanced Calculated Metrics

Avatar

Avatar
Give Back
Level 1
sowmyap94858964
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Give Back
View profile

Avatar
Give Back
Level 1
sowmyap94858964
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Give Back
View profile
sowmyap94858964
Level 1

22-06-2020

Hi,

 

We are tracking two sale values on our e-commerce platform currently -

Final Sale Price - the amount the user paid during checkout

Discount applied - the amount of discount applied to the purchase by the user during checkout

 

so in reporting, when we try to isolate the actual sale value across multiple purchase instances, which is a simple formula of Revenue - Discount, I start seeing negative values which is throwing up a wrong column total. 

 

Example: Final sale price for one instance was 0$ but the discount applied was 99 and so the sales(actual) is being reported as -99$. Is there a smart way to use calculated metrics to solve for these negative values? Wondering if anyone else faces the same issue?

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Affirm 25
Level 4
kainth
Level 4

Likes

49 likes

Total Posts

117 posts

Correct Reply

26 solutions
Top badges earned
Affirm 25
Give Back
Boost 5
Boost 3
Boost 25
View profile

Avatar
Affirm 25
Level 4
kainth
Level 4

Likes

49 likes

Total Posts

117 posts

Correct Reply

26 solutions
Top badges earned
Affirm 25
Give Back
Boost 5
Boost 3
Boost 25
View profile
kainth
Level 4

24-06-2020

@sowmyap94858964Please try to test the results for the calculated metric when no segment is applied to the Freeform table. Also, try adding the If condition in your calculated metric for example, If Discount is greater than 0 then show value as Revenue - Discount else just show the revenue. For more information on the If condition you can refer to the below documentation link.

 

Link: https://docs.adobe.com/content/help/en/analytics/components/calculated-metrics/calcmetrics-reference...

Hope this helps.

Regards,

Abhinav