Where and if conditional

[#1]

Hello

I want to do I do not know exactly the format expressions clause is as follows, but I'd appreciate if you can help.

=Count({<YAPILDI_MI=num(1)> (if (SON_FIILI_DURUM='KAPALI',GVG_UID))})

Thank you

[er_mohit]

Try this

Count({<YAPILDI_MI={1},SON_FIILI_DURUM={'KAPALI'}>}GVG_UID)

[er_mohit]

try this one also

Count({<YAPILDI_MI={1},GVG_UID=p({< SON_FIILI_DURUM={'KAPALI'}>}GVG_UID)>}distinct GVG_UID)

[#4]

Thank You  but, returned zero results

[#5]

zero again

[#6]

try this

count({<YAPILDI_MI=, SON_FIILI_DURUM={'KAPALI'}>}GVG_UID)

then select any data of YAPILDI_MI  field.

[#7]

In the first trial, but it did not

Count({<YAPILDI_MI={1},SON_FIILI_DURUM={'KAPALI'}>}GVG_UID)

[er_mohit · Accepted solution]

Hiiii

I think in your field YAPILDI_MI  is not one that's why it gives zero or try to check KAPALI field value in SON_FIILI_DURUM

If its right then try this one first to check value is coming or not

try this code

Count({<SON_FIILI_DURUM={'KAPALI'}>}GVG_UID) if data not comes then check fieldvalue if comes then

try the value of YAPILDI_MI={1} like this

Count({<YAPILDI_MI={1}>}distinct GVG_UID) if data comes then try above mentioned code

if not come then tell me where you got error..

[#9]

Thank you solved the problem YAPILDI_MI changed column