Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to make a 2 input fields with variables, one "Age from" and second "Age till". This will be Age range. And for exapmple, when i in the firs field i enter 20, in second 35, it must retur
only customers ho have age between 20-35. Please help.
my expresion is: =count({$<LastMembershipDueDate={ "<$(=Date(Today(), 'YYYY.MM.DD'))" },OfferingCategory1={'Narystės'} >}distinct CustomerID )
count({$<LastMembershipDueDate={ "<$(=Date(Today(), 'YYYY.MM.DD'))" },OfferingCategory1={'Narystės'}, Costumer.Age = {>=$(minAge)<=$(maxAge)} >}distinct CustomerID )
hope this helps!
regards,
MT
Can you post sample data or sample apps?
count({$<LastMembershipDueDate={ "<$(=Date(Today(), 'YYYY.MM.DD'))" },OfferingCategory1={'Narystės'}, Costumer.Age = {>=$(minAge)<=$(maxAge)} >}distinct CustomerID )
hope this helps!
regards,
MT
minAge and maxAge would be the name of your variables
What is the definition of Min and Max Age?
Here are 2 ways of doing it
like she posted at the beginning she has to input fields where she types in the min and max age! and and inputfield usually needs a variable to save the input value.
Thanks all of you, i little modified Magdalens set analysis and it works
count({$<LastMembershipDueDate={ "<$(=Date(Today(), 'YYYY.MM.DD'))" },OfferingCategory1={'Narystės'}, Customer.Age = {'>=$(minAge)<=$(maxAge)'} >}distinct CustomerID