help comparing fields in two columns using if statement

[Anonymous]

hey everyone, I am relatively new to the community. I have a question. I have a table shown below

I need a statement that will select the higher revenue if profit in Q1 and Q2 of id 1 are the same.

Thanks!

[sunny_talwar]

Where are you looking to do this? in a straight table or another object? What are you dimensions in the object? Can you supply us with a sample to check this out?

[jonathandienst]

In a straight or pivot table, something like this:

If(Count(TOTAL <id> Quarter) > 1 And Count(TOTAL <id> Distinct Profit) = 1, Max(TOTAL <id> Revenue), Revenue)

[Anonymous]

thanks guys for the response, so this is the main table. Please dont mind the erased part, they are same number>

as you can see different plants have different storage locations. I need another field that will serve as a flag to indicate the higher current stock if the storage locations are same but different plants.

I hope that makes sense. Please your response will be greatly appreciated.

Thanks!