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.
