Skip to Content
0
Former Member
Sep 17, 2007 at 05:22 PM

Similar to my easy one, but a bit different!

15 Views

Post Author: cmainard

CA Forum: Formula

I thought I could use the same concept, but its not returning the expected results.

648300011064840015006586000010

In the example above the bolded detail is a summary field:

{DistinctCount of MoxyAllocation.PortID}

Here is the formula I'm attempting:

if DistinctCount ({MoxyAllocation.PortID}, {MoxyAllocation.OrderID})>=1 then "0000" else if DistinctCount ({MoxyAllocation.PortID}, {MoxyAllocation.OrderID})>=10 then "000" else if DistinctCount ({MoxyAllocation.PortID}, {MoxyAllocation.OrderID})>=100 then "00" else if DistinctCount ({MoxyAllocation.PortID}, {MoxyAllocation.OrderID})>=1000 then "0"else "000000"

Basically I'm trying to get the line detail to shrink and grow to the right size...