Hi community,
I have a working expression in the initial value box of a column [Nails (Framing) (1,000/box):
Nails (Framing) (1,000/box)] :
=IFS([Case #].[Scope Of Work]=“Major or Minor Repairs”, [Case #].[LF of Wall Framing Needed]*6+[Studs - 2" x 4" x 8’]*8+IF([Studs - 2" x 4" x 8’]>0,50,0), [Case #].[Scope Of Work]=“1 Bed Room - New Build”,“2”, [Case #].[Scope Of Work]=“2 Bed Room - New Build”,“3”, [Case #].[Scope Of Work]=“3 Bed Room - New Build”,“3”)
[Case #].[LF of Wall Framing Needed]*6 = 90 [Studs - 2" x 4" x 8’]*8= 160
Plus the last if = 300
I now want to round up that result to 1000 and then have the result show 1 as in 1 box of 1000 framing nails
any body know how to add thsito the above expresion???
thank you for all your help
LinkedIn
Twitter
