DIFFERENCE

Q&A
,
1

I want to compare two values

image
image1999×103 7.85 KB

I want to calculate the difference of the value “PESO CANAL IN MX” vs the value “PESO CANAL IN US” (delta)

2

Hi @Geral,

Computing the number is probably possible in the Calculated field.

However, important question is how do you want to show this in the visual. Can you provide us the expected presentation of this data?

Regards,
Giri

3

Hi @Geral
you could use table calculation with the pivot table. but isnt nice solution.
Any chance to calculate it on database level?
BR

1 Like
4

Hi @Giridhar.Prabhu, I want to show mi data in this way

image
image1208×205 18.7 KB

I try to do the calculation in this way
image
image1360×283 11 KB

1 Like
5

Hi @Geral

See if the following approach would work for you?

1 Like
6

Hi @Geral,
It’s been awhile since we last heard from you, did you have any additional questions or were you able to find a work around?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

7

Hi @Geral,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!