Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
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
Please post a sample app..
hello @trdandamudi,
thank you for the try but it doesn't solve the problem yet, the result is 0 !!