Resultados 1 al 7 de 7

Tema: Wrong schedule formula calculation

  1. #1
    Junior Member
    Fecha de Ingreso
    19 ene, 17
    Mensajes
    13
    Hora local
    01:24

    Not allowed! Not allowed!

    Wrong schedule formula calculation

    Hello

    I'm trying to calculate something with a Revit schedule, but the calculated value i wrong?

    I've made to parameters called "GWP (MIP_K)" and "R_MIP - GWP".

    GWP (MIP_K) = 4,88
    R_MIP - GWP = 9,38

    And then I made the formula: GWP (MIP_K) / R_MIP - GWP

    But it's wrongly calculated to 1,47 and not 0,52 as it should be.



    If I use a "+" and not "/", its works perfectly fine, but I need to divide it.

    this formula: GWP (MIP_K) + R_MIP - GWP = *14,26‬ is correct??


    Can anybody tell me what migth be wrong?

  2. #2
    Moderator Avatar de snowyweston
    Fecha de Ingreso
    21 dic, 10
    Ubicación
    C.LONDON
    Mensajes
    4,415
    Hora local
    00:24

    Not allowed! Not allowed!
    Cita Iniciado por Krogstrup Ver Mensaje
    Can anybody tell me what migth be wrong?
    Wild guess, you've other parameters MIP_K and GWP elsewhere - and Revit is confusing them in your calculation because you have mathematical annotation in your parameter names, specifically:


    GWP (MIP_K)
    R_MIP - GWP

    you really don't want that stuff anywhere near numeric parameter names if you're ever going to do anything with formulas with their values.

  3. #3
    Junior Member
    Fecha de Ingreso
    19 ene, 17
    Mensajes
    13
    Hora local
    01:24

    Not allowed! Not allowed!
    I'd tried to change all the names from "-" to "_" and removed all parenthesis, but nothing has changed in the calculated value.

  4. #4
    Moderator Avatar de snowyweston
    Fecha de Ingreso
    21 dic, 10
    Ubicación
    C.LONDON
    Mensajes
    4,415
    Hora local
    00:24

    Not allowed! Not allowed!
    What are unit types of each parameter, and the unit type of the calculated value?

    (Screenshots help things immeasurably)

  5. #5
    Moderator Avatar de DaveP
    Fecha de Ingreso
    10 ene, 11
    Ubicación
    St Paul, MN
    Mensajes
    3,068
    Hora local
    18:24

    Not allowed! Not allowed!
    I agree with Snowy. Not a good idea to use special characters in your parameter names.
    Even if it doesn't stuff up the calculation, it makes them hard to read & somewhat ambiguous.
    I'm not a big fan of spaces, either. BetterToUseCamelCase.
    If you absolutely MUST have () or - or * in your parameters, you'll have to surround the parameter with square brackets:
    [GWP (MIP_K)] / [R_MIP - GWP]
    And now that I look at that again, I thought your original formula divided GWP (MIP_K) by R_MIP and then subtracted GWP

  6. #6
    Junior Member
    Fecha de Ingreso
    19 ene, 17
    Mensajes
    13
    Hora local
    01:24

    Not allowed! Not allowed!
    I think I found the reason to my problem, but I can't seem to solve it.
    The schedule was unsorted and the numbers show where the total. I thought that this was fine, but it do not calculate the total values.

    Altso I changed a lot of the names and added the parameters to the formula. So now it's the "MIP_B"-group divided with "R_MIP"-group, which should equals X_GWP

    Schedule:
    Pulsa en la imagen para verla en tamaño completo

Nombre: total.PNG
Visitas: 9
Tamaño: 5.0 KB
ID: 36634

    Formula:
    Pulsa en la imagen para verla en tamaño completo

Nombre: Formula.PNG
Visitas: 8
Tamaño: 14.1 KB
ID: 36635


    When I sort the schedule I can see there the calculation error is. It calculates each category and do not use the totals. Is there any way to solve this problem?

    Sorted schedule:
    Pulsa en la imagen para verla en tamaño completo

Nombre: Sorting.PNG
Visitas: 10
Tamaño: 7.8 KB
ID: 36636

  7. #7
    Moderator Avatar de snowyweston
    Fecha de Ingreso
    21 dic, 10
    Ubicación
    C.LONDON
    Mensajes
    4,415
    Hora local
    00:24

    Not allowed! Not allowed!
    As you have discovered - calculated fields (in Revit schedules) do not, without some considerable hackery, do not consider in-line/row/column totals.

    Search out Ekkonap's posts on the method (I think in the "formulas for everyday use" thread)

Temas Similares

  1. Duct connector causing formula to allow wrong answer?
    Por jturovskiy en el foro MEP - Family Creation
    Respuestas: 1
    Último Mensaje: 17/04/2019, 11:14
  2. Unexpected Value Rounding with a Calculation Formula
    Por cellophane en el foro Architecture - Family Creation
    Respuestas: 2
    Último Mensaje: 24/10/2018, 20:52
  3. Area calculation wrong - Schedules
    Por MARIA1993 en el foro Architecture and General Revit Questions
    Respuestas: 0
    Último Mensaje: 22/03/2018, 14:31
  4. Help!!!!!!! with Calculation Value in a schedule
    Por roadiedesigns en el foro MEP - General
    Respuestas: 2
    Último Mensaje: 28/07/2013, 02:19
  5. Schedule formula (is there a formula expert in the house?)
    Por John McCamont en el foro Architecture and General Revit Questions
    Respuestas: 8
    Último Mensaje: 09/09/2011, 21:50

Etiquetas para este Tema

Permisos de Publicación

  • No puedes crear nuevos temas
  • No puedes responder temas
  • No puedes subir archivos adjuntos
  • No puedes editar tus mensajes
  •