Bug ReportsFormula Bug?
Not sure if I have this formula incorrect or there is a bug, I do the math manually and I should get 260
In simple terms, my total conduit length is multiplied by the number of CCTs divided by the CCTs / HR
40.98+20=60.98
# of CCTs is 17, CCTs per HR is 4, 17/4 = 4.25
60.98*4.25=259.16
With my option to round to nearest 10, the result should be 260, not 70
if([.# of CCTs/qty] < [CCTs / HR],(sum('qty')+[Linear:FT]),((sum('qty')+[Linear:FT]))*([.# of CCTs/qty]/[CCTs / HR]))
I had to add ./ for the # of CCTs, then this works:
if([./# of CCTs/qty] < [CCTs per HR],(sum('qty')+[Linear:FT]),((sum('qty')+[Linear:FT]))*([./# of CCTs/qty]/[CCTs per HR]))
Great, thanks for sharing with the community!
Sorry there still is a slight issue: If I do the math on this:
42.10+20 = 62.1
#of CCTs = 6
CCTs per HR = 4
6/4=1.5
62.1 * 1.5 = 93.15, this then should round this up to 100, I even took out the if then statement to test if had something to do with that.
I'm not positive if this works, but you could try as a workaround:
ceil(((([.# of CCTs/qty] / [CCTs / HR]) * (sum('qty') + [Linear:FT]))) / 10) * 10
This part of the formula is returning a 0 ([./# of CCTs]/[CCTs per HR])
Should be 1.5
([./# of CCTs/point count]/[CCTs per HR]) I did this and it return 1
Looks like this wont allow a decimal value
I have it fixed now, I was confusing myself I divded 6 into 6... thats 1, instead of 6 into 4. Thanks