Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone help me with this expression;
If FBÅR > EEAAR then SUMMARGIN
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)
SUM(IF(FBAR > EEAAR, MARGIN))
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)
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.
Not sure I understand still. Would you be able to share a sample with the expected output?