Help with expression

[vijetas42]

Hi All,

I am having data like below,

Key	name	monthyear	fee
1	1-aa	1312018	3850
1	1-aa	2282018	0
1	1-bb	1312018	0
1	1-bb	2282018	0
1	1-cc	1312018	0
1	1-cc	2282018	0

where my requirement is i need only those key and name where fee has been changed over month.

expected output is,

1

1-aa

2282018

0

Please help with the expression.

[olivierrobin]

hello

you can use an expression like

date(monthyear,'DMMYYYY')>Reference Date (you may need to use date() function arond you reference date)

[vijetas42]

i don't want to calculate reference date.

[olivierrobin]

is you reference date the beginning of the month ?

[tresesco]

May be like:

where fee<>Peek(fee);   // to avoid the first row you might use 'and recno()>1' as additional clause

[vijetas42]

for now i have added expression to fee like,

IF(fee<> Above(TOTAL fee),sum(fee)) so it's showing whole table with value for changed key but, also showing other key with null values.

it's giving output like,

Key	name	monthyear	fee
1	1-aa	1312018	-
1	1-aa	2282018	0
1	1-bb	1312018	-
1	1-bb	2282018	-
1	1-cc	1312018	-
1	1-cc	2282018	-

but i want only second row where value is there

[tresesco]

PFA

[vijetas42]

Thanks Tresesco!

It worked but i have one doubt that in rangemax(sum(fee),0.0000001) what does 0.0000001 indicates? because when I used only 0 it's not working.

[tresesco]

That's to avoid 'zero suppression'. You have to be sure if you could afford to have small fraction in the chart calculation.

[vijetas42]

Thanks for all your help