Hi All,
I have a requirement like this...
Item Amt
C 10
D 11
E 12
F 13
G 0
When ever the Item = 'G' and Amt = 0 then Item values C,D shouldn't display in the column values.
For this i have an idea (i am not sure whether it will work or not).
1. Create a formula
2. In the formula create an Array and read all the values of Item into that.
3. In the array by putting a condition like when Item = C or D supress the rows.
Can we achieve this with arrays .. ?
I am not much expert in writing array in CR.
Please help me in this issue.
Thanks,
Subash