Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have a requirement related to the below table.
Policy | Reference |
---|---|
P1 | V1 |
P1 | - |
P2 | V2 |
P3 | V3 |
P4 | - |
P5 | V4 |
The requirement is that ALL Policies that have a Reference and also have a NULL reference then we have to show Only the one that has a Reference.
Example : P1 has reference V1,NULL then we will show the row only for V1
On the other hand if there is a Policy that has one or many null references(none of the reference here have a value)
Example : P4 , then we display this policy.
The output required is like below. How do we achieve this?
Policy | Reference |
---|---|
P1 | V1 |
P2 | V2 |
P3 | V3 |
P4 | - |
P5 | V4 |
Thanks in advance,
Rajesh Vaswani
hi,
try using maxstring(Reference) as your expression.
make sure tjhe option suppress zero-values is not ticked on the presentation tab.
Hi,
Thanks for the reply. If we use maxstring(Reference) then it will return only one value for that policy. But if i have more number of References for the same policy then i need to display all the references which are not null.
Also i am using table object here as we do not have any calculations.
Please suggest.
Hi,
Further to the question I has asked. In a simplified way this is what is expected.
Policy | Reference | Policy Count | NULL Flag |
P1 | V1 | 2 | 0 |
P1 | - | 2 | 1 |
P2 | V2 | 1 | 0 |
P3 | V3 | 1 | 0 |
P4 | - | 1 | 1 |
P5 | V4 | 1 | 0 |
When Policy Count is greater than 1 and NULL Flag is 1(Reference is NULL) then we need to hide that row. Could someone help with a way/expression to do this?
Thanks,
Rajesh Vaswani
What object are you using to display the table? simple table, pivot table or a table box?
If it's a table box you can just go to the presentation tab, select the reference field and select option "omit rows where field is null".
If you're using a chart then you can have either an if or a set analysis in the formula, something like if(not isnull(Reference),sum(value)) or sum({<Reference={*}>}value).