count expression with conditions

[JMAROUF]

hello every one,

i have an issu with this expression : 

=num(count({1 < [field1]={'val1','val2','val3','val4','val5','val6','val7','val8,'Val9','val10'},
[field2]={'>0'},[field3]={'>0'} >} distinct target),'# ##0')

it gives a wrong result.

[trdandamudi]

Please give a try with the below expression:

=count({1<field1={'val1','val2','val3','val4','val5','val6','val7','val8','Val9','val10'},field2={'>0'},field3={'>0'} >} distinct target)

Hope this helps.

[Prashant_Naik · Accepted solution]

Hi,

This might help, I have bold the changes

num(count({1 < [field1]={'val1','val2','val3','val4','val5','val6','val7','val8,'Val9','val10'},
[field2]={">0"},[field3]={">0"} >} distinct target),'# ##0')

Regards,

Prashant

[sasiparupudi1]

Please post a sample app..

[JMAROUF]

hello @trdandamudi, 

thank you for the try but it doesn't solve the problem yet, the result is 0 !!