Use greater than function

[#1]

Hi All,

I need to calculate the sum of a column based on greater than functionality of other 2 columns but I am not able to do the same.

E.g.

Column1 Column 2  Column 3

01              02            10

02              03             10

01              02             10

What I am trying to achieve here is

If(Column2) > Column (1) then Sum( Total)

Which means it should provide me a total sum of all Column 3 where Column2 > column 1

I tried deriving an expression; but did not work.

Any help on this would be highly appreciated as I am stuck on this for Quite a few hours.

Regards,

Prathamesh Sable

[#2]

Mariu,

I Tried, Still getting data discrepancy. Using the normal formula

=Sum(IF(Accepted age)>(accept_TM), Total) gives me a count of 23167

performing the same in excel gives me a count of 24175

Same data has been loaded in Qlikview still data error

Regards,

Prathamesh