Forums >> General Discussion >> Revit Project Management >> If Statement in Schedules' Calculated Value

pleojera

active

Joined: Mon, Sep 16, 2013
0 Posts
No Rating

Hi,I am trying to calculate different calculations according to "Material: Mark". For example, i have 2 materials whose marks are "m²" and "m³". I want it to calculate ParameterA*ParameterB if mark is m² and vice versa.But when i click OK, it says "m² is not a valid schedule field." Here is my IF statement:      IF (Material: Mark = m², "ParameterA*ParameterB", "ParameterC*ParameterD")             Any suggestion? 

Edited on: Wed, Aug 13, 2014 at 6:07:28 AM

Edited on: Wed, Aug 13, 2014 at 8:57:26 AM

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

If you would read your HELP (Always the first place to start): http://help.autodesk.com/view/RVT/2014/ENU/?guid=GUID-A0FA7A2C-9C1D-40F3-A808-73CD0A4A3F20 then you would see:

IF with a text parameter: =IF (Length > 35', “String1”, “String2&rdquo

This user is offline

pleojera

active

Joined: Mon, Sep 16, 2013
0 Posts
No Rating

 I did read actually. Still couldn't figure it out. My condition is being m² or being m³. But it says, "the following is not a valid schedule field : m²" 

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

Look again at the help.  What type of parameter is your mark?  I am assuming it is text.... whell then when you look at the Help, you see that strings (text) have to be enclosed in "XXXX". 

In addition, Revit doesn't understand mixed case.  So do you really want M2 and M3 instead of what you are trying to do?

This user is offline

pleojera

active

Joined: Mon, Sep 16, 2013
0 Posts
No Rating

Thank you very much for your patience Yes, it is text. But it doesn't matter if it is m³ or ABC. It is still saying "not valid schedule field."  If it is not too much to ask; could you please write it for me to try? What i want is, if "Material: Mark" is "m²", it should multiply "Malzeme Miktar M²" and "Material: Cost". If it is not "m²" (or if it is "m³"), it should multiply "Malzeme Miktar M³" and "Material: Cost".  Thanks by now.

Attached Images

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

You don't seem to understand....

Your units have to be correct!  Text is text and must have " quotes" around it!  What unit type is material mark?  A material Mark is text!  In addition, m² can not exist in Revit as text or as a number!!!!

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

In addition, You can't multiply text!

If (Material = "ABC", Number1* Number2, Number3)  <<< Numbers are numbers - Material is text.

This user is offline

pleojera

active

Joined: Mon, Sep 16, 2013
0 Posts
No Rating

Oh no no. Multiply ones are already regular numbers. I misunderstood you, sorry. I suppose i have to duplicate material cost too ( i forgot this, yeap) as numbers and change special characters in material mark. Thanks for your help! (i am trying to read, reply and understand while i am on my phone and in a crowded bus i accidently pressed and reported your previous message as offensive. Sorry about that too. )   Gosh what a terrible day! 

This user is offline

if yes/no statement controlled by if yes/no statement

6

Calculated Value

3

Help with If then statement [ 1 2 ]

17

OCCUPANT LOAD FROM CALCULATED VALUE/IF STATEMENT

1

Schedule Calculated Values

0