We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

השב: Rule to checking grid values against a single textbox

Hi,
There must be a better way than running 30 rules or more.
Would be glad to help you. Do you have the paper version of the scale and the instructions how it should be completed and scored?
Best regards
Shmulik
נשלח מה-HTC שלי
----- Reply message -----
מאת: "Lindsay Stevens"
אל: "'[email protected]'" , "'[email protected]'"
נושא: [Users] Rule to checking grid values against a single textbox
תאריך: יום ה', אוק 25, 2012 09:38
Hi All,

I’ve been working on what is probably not the first (nor the last) implementation of RECIST v.1.1 in OpenClinica. The CRF setup is that target lesions are recorded in rows of a grid on one tab, and sum of lesion measurements field is on the following tab. I’d like to have some way to check that the measurements are totalled correctly by the user. Attached are a couple of screen shots of the CRF to illustrate.

Given that:
- group-calculations don’t work if there is a null value in the array (the field returns ‘’), and
- the value of zero for measurements has a meaning (complete disappearance of the lesion) so zero can’t be used to avoid null, and
- it is appropriate to have a null value in some cases (the lesion was not assessed at the visit), and
- subjects can have 1, 2, 3, 4 or 5 target lesions evaluated throughout the study, but are only expected to add ‘enough’ rows;

the solution I’m thinking of is to write a rule to check whether or not the sum the user has entered is correct. However, rules also fail to run when null values are in the array, so I can’t just write the equivalent of:

‘does lesion 1 value + lesion 2 value + lesion 3 value + lesion 4 value + lesion 5 value = target lesion sum field’

So the rule it seems I need to write has to cover all the cases of there being a value and there being a null, for a minimum of 1 and maximum of 5 lesions, e.g.

- 1 lesion recorded:
- does lesion 1 value = sum

- 2 lesions recorded:
- does lesion 1 value + lesion 2 value = sum,
- does lesion 1 value = sum if lesion 2 value is null,
- does lesion 2 value = sum if lesion 1 value is null

- 3 lesions recorded:
- does lesion 1 value + lesion 2 value + lesion 3 value = sum,
- does lesion 1 value + lesion 3 value = sum if lesion 2 value is null,
- does lesion 2 value + lesion 3 value = sum if lesion 1 value is null

... and so on for all the combinations, for up to 5 lesions. I think works out to about 30 cases.

Before I go off and give myself a headache by writing this gargantuan rule, I wanted to check if anyone out there had come across a similar problem and were willing to share their solution, or if anyone had any insights on writing this rule that might simplify the rule expression.

Best regards,

Lindsay Stevens | Clinical Data Coordinator
NHMRC Clinical Trials Centre, THE UNIVERSITY OF SYDNEY
Office: Level 2, 6-10 Mallett St | Camperdown | NSW | 2050
Mail: Locked Bag 77 | Camperdown | NSW | 1450
T +61 2 9562 5369 | F +61 2 9562 5094
E [email protected] | W www.ctc.usyd.edu.au

This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal
IMPORTANT NOTICE: This e-mail and any attachment to it are intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. The CTC is not responsible for any unauthorised alterations to this e-mail or attachment to it. Views expressed in this message are those of the individual sender, and are not necessarily the views of the CTC. If you receive this e-mail in error, please immediately delete it and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient.
This discussion has been closed.