Formula Help

Mon, 30 Apr 2012 11:16:02 GMT

sum({1<Tarih={'>=$(=vcurrentyear)'},AKREDITIF_PC={'USD'},yil

= {$(currentyear2)}>}AKREDITIF_KULLANILANTUTAR)

I have a formula which is shown above . This formula Works truly. As you may know; this colored statements are “fields” that we took them from our database and the remain are variables and other parts of formula.

I would like to add a new field but “Conditional Field”.

I want to add this field to the my formula : “AKREDITIF_YUKTARIHI“

This field is “date field” that Shows date of “Letter of Credit” (l/c).

in my above formula, “AKREDITIF_KULLANILANTUTAR field” includes data of “AKREDITIF_YUKTARIHI“,however, I just exactly want AKREDITIF_YUKTARIHI is 0 or no value.

Now; I would like to bring data by composing formula in such way;

Bring result/data of above formula ; if “AKREDITIF_YUKTARIHI“ is zero not have value.

In sum; bring my data, by excluding of “AKREDITIF_YUKTARIHI“’s data.

topic Formula Help in QlikView

Formula Help