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...