Display documents according to formula

HCL Domino Domino Forum
1

Hi All,

I need your assistance. I have two fields in my form called appQuestions and appAnswers. However in a number of cases I have more answers (appAnswers) than questions (appQuestions).

How could I write a simple formula to get all documents that have more answers than questions. I intent to run this formula from a view.

Thanks

John

2

Subject: Display documents according to formula

Set view formula as following

SELECT Form = “FormName” & ( appAnswers > appQuestions )

Make sure your both fields contains Number Values always.

3

Subject: Display documents according to formula

SELECT @elements(appQuestions) <> @elements(appAnswers)