Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have two fields RiskID and DATE.
I have created previous date and current date by using us. if I select one date from previous and one date from current it will give few RiskIDs .
Now I want to get the count of RiskIDs which are not present in previous date but it present in current date.
how to implement the above requirement.
Thanks.
Hi,
how did you create the previous date and current date ? on the script ? two different separated fields ?
if that's what you have, you can try this:
Count({<Previous_date-={'$(=Getfieldselections(Previous_date))'}>}RiskIDs)
After making some test, I would recommend this (I don't know why)
Count({<Previous_date =- {'$(=Getfieldselections(Previous_date))'}>}RiskIDs)
the only difference is the position of the minus sign - near the equal sign, before or after
thanks for your reply Youssef. I will check your expression it works or not.