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
User | Count |
---|---|
40 | |
35 | |
30 | |
23 | |
17 |