This content has been marked as final.
Show 5 replies
-
-
2. Re: Calculate distinct amount of a subset
Rody Zakovich Mar 3, 2016 5:50 AM (in response to Rgg Rowe)Hello Rowe,
You'll need to use an LoD (Assuming I understand the requirement correctly)
SUM({ FIXED [Name] : MIN([Valid]) }) / COUNTD([Name])
That will return a Single 1 or 0 For each NAME depending on if there is a Valid record for that name.
And the result of the Calc is 0.5
Hope that helps.
Regards,
Rody
-
3. Re: Calculate distinct amount of a subset
Rgg Rowe Mar 3, 2016 6:07 AM (in response to Rody Zakovich)So appreciate Rody ! The LoD solution works for me.
Thank you very much again.
-
4. Re: Calculate distinct amount of a subset
Rody Zakovich Mar 3, 2016 6:09 AM (in response to Rgg Rowe)No problem. Glad I could help.
If you run into any problems let me know.
Regards,
Rody
-
5. Re: Calculate distinct amount of a subset
Rgg Rowe Mar 3, 2016 6:43 AM (in response to Rody Zakovich)I will. Have a nice day