Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team ,
Please help me to complete this task .. I got one new requirement , I have a filter called ID. When I select ID it will show the values in another table .
My table:
name | address | phone |
a | 87 | |
b | 88 |
Here we have 6 results and 2 null values , so I have to calculate overall results ,and null values and completeness based on the table ,, so my result would be
count : Overall values
null count: null value count
completeness : null values/overall count
name | address | phone | count | null | completeness |
a | 87 | 3 | 1 | ||
b | 88 | 3 | 1 | ||
overall 6 | null 2 | 0.67 |
Thanks,
Deepak
There you go:
I think you have mistakes in your completeness logic.
null=2
full=6
completeness = null/full = 0.333
But your result showing 0.67, so I did both.
Do check which logic suits you better.
Refer qvw attached as reference.
Thanks and regards,
Arthur Fong
Do you have a sample app?
I don't have a sample to share for this .. My requirement is If you have a table that how may overall values and how many nulls and completeness for the table ..
Thanks,
Deepak.
There you go:
I think you have mistakes in your completeness logic.
null=2
full=6
completeness = null/full = 0.333
But your result showing 0.67, so I did both.
Do check which logic suits you better.
Refer qvw attached as reference.
Thanks and regards,
Arthur Fong
Thanks jkfong93 ..yes , Its working ..