Dear friends, I want to add a constraint to the left and right input values corresponding to the line items. If they exceed 100, an error will be reported. Is there any good way?
hi Case 1: Sum of left and right are greater that 100 you can create a line item of text format and then you can display desired error message and can apply conditional format as well. Case 2: Individual limits if entered greater than 100 also you can display error by creating line items. Screenshot for reference
Hope it helps.
Hi, you can sum both right and left values in 3rd line item(Number Format) if right+left >100% then 1 else 0, then use this 3rd line item as conditional formatting to highlight right and left fields.
Hi ALL, I have a module where a line item (Assignments column) is formatted by a large ‘Projects’ list. Each record is assigned to a Project and this module is published to a UX page. When users apply a filter on the Assignments column, the filter dropdown displays the entire Projects list (since the column is…
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
