Hi All, I have a requirment in my Interface that I am displaying the data in a grid through Expression rule . But in that there are some fields like say isA , isB and isC with 0 and 1 value in database . But now the The condition is that I have to show the Yes , No , N/A instead of 0 and 1 on some conditions like
1. If isA is 0 in database then isB and isC should be N/A in the grid and isA will No in the grid
2. If isA is 1 and isB is 0 in the database then isA will be yes , isB will No and isC is N/A in the Grid
3. If isA is 1 and isB is 1 in the database then isA will be yes , isB will be Yes and isC yes/No based on value in database
Thanks in advance
Discussion posts and replies are publicly visible
if(all(fn!isnull,{ri!isA,ri!isB,ri!isC}),{"NA","NA","NA"}, a!forEach( items:{ri!isA,ri!isB,ri!isC}, expression: fn!displayvalue(fv!item,{0,1},{"No","Yes"},"NA") ) )