Hi community, I have a working expression in...


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


Just resolved