Sum if year greather then HELP

[Anonymous]

Hi,

Can anyone help me with this expression;

If FBÅR > EEAAR then SUMMARGIN

[MK_QSL]

SUM(IF(FBAR > EEAAR, MARGIN))

[sunny_talwar · Accepted solution]

Or you can create a flag in the script if the two fields come from the same table

LOAD FBAR,

          EEAAR,

          If(FBAR > EEAAR, 1, 0) as Flag

FROM .....;

and then on the front end, like this

Sum(MARGIN * Flag)

[Anonymous]

Hmm,. the resault was not what i was looking for, let me explain further;

If FBÅR is less then ERAARAR i want it to sum the margin in one collum to the left in the chart.

Like; ERAAR is 2016, FBÅR is 2015, 2014 or 2013.

[sunny_talwar]

Not sure I understand still. Would you be able to share a sample with the expected output?