How to compare data items

[barrysaab]

Hi Folks,I have two data items namely Type and Amount,In Type there are type1 and type 2 so on,I need to compare

type=1 total amount > type=2 total amount,How to do this,thanks in advance.

[BigChris]

Would something like this work:

total(if([Type] = 'Type 1') then ([Amount]) else (0)) > total(if[Type] = 'Type 2') then ([Amount]) else (0))

You might need to play around with before or after aggregation...but it might work.

[barrysaab]

Thanks BigChris,It did worked.Apologies for delayed response.