IF Function field in Set Analysis

[#1]

Hey,

I need to apply date filter on expression in a table, which has values that are not connected with any CREATEDATETIME. So I need to apply this filter only on fields which are not null.Here is my set analysis which won't work.

sum ({<[$(=if(not isnull(ZpoGr.CREATEDDATETIME),ZpoGr.CREATEDDATETIME))]= {$(='">='&DATE(zpgCreateDT_From2) & '<=' &DATE(zpgCreateDT_To2) & '"')}>}InvOut.AMOUNTCUR)

Thanks for help

UPD I have problems only with the left part of the expression - the right one works correctly

[#2]

sum ({<

                     [$("=if(ZpoGr.CREATEDDATETIME<>' ',ZpoGr.CREATEDDATETIME)"]= {$(='">='&DATE(zpgCreateDT_From2) & '<=' &DATE(zpgCreateDT_To2) & '"')}>}InvOut.AMOUNTCUR)

[#3]

the same result

[Sokkorn]

Hi,

Can you try this set analysis and let me know the result

=Sum({$<[ZpoGr.CREATEDDATETIME] = {">=$(=Date([zpgCreateDT_From2]))<=$(=Date([zpgCreateDT_To2]))"} >} [InvOut.AMOUNTCUR])

Note: make sure you have same date format in field [ZpoGr.CREATEDDATETIME],[zpgCreateDT_From2] and [zpgCreateDT_To2]

Regards,

Sokkorn

[#5]

the problem is that I have to check if the value is not null, cause without this check the filter reduces all lines which have no CREATEDDATETIME even when the filters are empty

[Sokkorn]

Hi,

=Sum({$<[ZpoGr.CREATEDDATETIME] = {">=$(=Date([zpgCreateDT_From2]))<=$(=Date([zpgCreateDT_To2]))"},
[ZpoGr.CREATEDDATETIME] -= {$(=IsNull([ZpoGr.CREATEDDATETIME]))}
>} [InvOut.AMOUNTCUR])

Second line of set analysis above will exclude null value from your field. Let give it a try. If possible, attacched your sample att here.

Regards,

Sokkorn

[#7]

Something wrong with syntax.

Thanks for your attension, but we decided to find another way.

[Sokkorn]

Hi,

Any sample app? then we can easy to find a new solution.

Rgds,

Sokkorn

[#9]

unfortunately, now I have no permission to attach a file

Thank you