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.
"Never exist before" is not the same as "never exist in last year"... Anyway, see if the attached helps.
