Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
i have a text box
in which i have wriiten the code as below fro getting duplicate groups
=Count(Aggr(If(Count(GROUP_NAME) > 1,GROUP_NAME),GROUP_NAME))
now i want the percentge of that, how to do in text box
May be this
Num(Count(DISTINCT {<GROUP_NAME = {"=Count(GROUP_NAME) > 1"}>} GROUP_NAME)/Count(DISTINCT GROUP_NAME), '##.0%')
please its urgent , can anyone help
Are you not seeing my response above?
Try this:
num(Count(Aggr(If(Count(GROUP_NAME) > 1,GROUP_NAME),GROUP_NAME))
/
count({1}GROUP_NAME),'##.0%')
Br,
KC