requirement

[Anonymous]

               I have a expression like:

count(id)

I have created a variable which is picking up my latest date from my date field

now I want to use it over here with this expression,

how to do that?

[tresesco]

May be like:

=Count( {<Date={'$(vMaxDate)'}>} id)

[Anonymous]

I have one more condition to add in this

:field={y}

how to do that

[tresesco]

=Count( {<field={'y'}, Date={'$(vMaxDate)'}>} id)  Set Analysis: syntaxes, examples

[Anonymous]

load id

where

field1='value' and (field2='NA' or isnull(field3)) and field4<>'NA' and (curr_ele_brand<>'null' or field5<>'null')

cnvert this to set analysis how?

[tresesco]

If your original query is answered to your satisfaction, please close it by marking correct/helpful as applicable.

Few suggestions:

• put a proper caption/heading to your query unlike 'requirement'; that would help you get answer faster and better may be.
• don't continue one answered thread with a another query.
• mark helpful/correct replies as fit - to keep people motivated to help you.
• when you post a query, try to be more descriptive about your problem and support your case with sample app and/or sample data.

I guess, I have already replied to your similar query couple of hour back and you didn't confirm it it was helpful or 'not working'. Try to continue with that thread..set analsis expre