Help with inconsistent units in formula

[Sahay_R]

I am trying to create a formula that multiplies an area parameter by a number. I am trying to calculate Net Square Footage for rooms by subtracting the area of casework ( a text shared parameter that is entered manually) multiplied by the number of casework (again, a manually entered text parameter) I am frustrated by the 'inconsistent units' error message that pops up all the time. Is there a conversion factor involved? Any words of wisdom would be appreciated.

[ToanDN]

---

@rsahayUZMK9 wrote:

I am trying to create a formula that multiplies an area parameter by a number. I am trying to calculate Net Square Footage for rooms by subtracting the area of casework ( a text shared parameter that is entered manually) multiplied by the number of casework (again, a manually entered text parameter) I am frustrated by the 'inconsistent units' error message that pops up all the time. Is there a conversion factor involved? Any words of wisdom would be appreciated.

---

the area of casework: needs to be an Area parameter

number of casework: needs to be a Number or Integer parameter

[L.Maas]

In Revit a parameter of type text is text and can not be converted to a Number or Area

[Sahay_R]

Sorry I wasn't thinking as I typed. Senior moment here....

CW Area - area parameter, entered manually into Room

Number of CW - integer. Also entered manually into Room

The desired end result is a schedule.

[ToanDN · Accepted solution]

Works fine here:

[Sahay_R · Accepted solution]

TY. In the meantime, the version that worked for me was 

roundup(Area / 1 SF - (Number of Casework * Casework Area / 1 SF))

[ToanDN]

Strange.  Your formula suggests that the Net Area parameter is Number, not Area.