Bring back latest version

[cclayford_ric]

Hi all.

How do i bring back only the latest version (version 3 in this case) for leadbyte_id 400117. I assume i would need to use a combination of the parent_id and version somehow?

[gp_oconnor]

If this is the result you're after, then the expression below works:

=if(not IsNull(Only([parent_id])),
if(Only([version]) = Max(total <[parent_id]> version),
Only([parent_id]),
0
),
if(Count({<[leadbyte_id]=P([parent_id])>} [leadbyte_id]) > 0,
0,
Only([leadbyte_id])
)
)