Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear sirs , I have 2 fields , prod and year. How can I check the prod never exist in last year ? Please help.
this can possibly be achieved in different ways. can you give us an example of your data?
Maybe this:
only({<Year=E({<Year={"$(=year(today()))-1"}>})>} Product)
(just a guess, without seeing your app...)
Can you provide a sample app.
Dear sirs , Below is my sample data. When I select any year , I expect the result is to show prod never exist before. Please guide me. Thanks.
Year | Prod |
2015 | A |
2015 | B |
2015 | C |
2015 | D |
2015 | E |
2015 | F |
2014 | B |
2013 | C |
"Never exist before" is not the same as "never exist in last year"... Anyway, see if the attached helps.