Risultati da 1 a 7 di 7

Discussione: Wrong schedule formula calculation

  1. #1
    Junior Member
    Data Registrazione
    January 19, 2017
    Messaggi
    13
    Ora locale
    08:45 AM

    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 L'avatar di snowyweston
    Data Registrazione
    December 21, 2010
    LocalitÓ
    C.LONDON
    Messaggi
    4,415
    Ora locale
    07:45 AM

    Not allowed! Not allowed!
    Citazione Originariamente Scritto da Krogstrup Visualizza Messaggio
    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
    Data Registrazione
    January 19, 2017
    Messaggi
    13
    Ora locale
    08:45 AM

    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 L'avatar di snowyweston
    Data Registrazione
    December 21, 2010
    LocalitÓ
    C.LONDON
    Messaggi
    4,415
    Ora locale
    07:45 AM

    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 L'avatar di DaveP
    Data Registrazione
    January 10, 2011
    LocalitÓ
    St Paul, MN
    Messaggi
    3,068
    Ora locale
    01:45 AM

    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
    Data Registrazione
    January 19, 2017
    Messaggi
    13
    Ora locale
    08:45 AM

    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:
    Clicca sull'immagine per ingrandirla

Nome: total.PNG
Visite: 9
Dimensione: 5.0 KB
ID: 36634

    Formula:
    Clicca sull'immagine per ingrandirla

Nome: Formula.PNG
Visite: 8
Dimensione: 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:
    Clicca sull'immagine per ingrandirla

Nome: Sorting.PNG
Visite: 10
Dimensione: 7.8 KB
ID: 36636

  7. #7
    Moderator L'avatar di snowyweston
    Data Registrazione
    December 21, 2010
    LocalitÓ
    C.LONDON
    Messaggi
    4,415
    Ora locale
    07:45 AM

    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)

Discussioni Simili

  1. Duct connector causing formula to allow wrong answer?
    Di jturovskiy nel forum MEP - Family Creation
    Risposte: 1
    Ultimo Messaggio: April 17th, 2019, 11:14 AM
  2. Unexpected Value Rounding with a Calculation Formula
    Di cellophane nel forum Architecture - Family Creation
    Risposte: 2
    Ultimo Messaggio: October 24th, 2018, 08:52 PM
  3. Area calculation wrong - Schedules
    Di MARIA1993 nel forum Architecture and General Revit Questions
    Risposte: 0
    Ultimo Messaggio: March 22nd, 2018, 02:31 PM
  4. Help!!!!!!! with Calculation Value in a schedule
    Di roadiedesigns nel forum MEP - General
    Risposte: 2
    Ultimo Messaggio: July 28th, 2013, 02:19 AM
  5. Schedule formula (is there a formula expert in the house?)
    Di John McCamont nel forum Architecture and General Revit Questions
    Risposte: 8
    Ultimo Messaggio: September 9th, 2011, 09:50 PM

Tag per Questa Discussione

Permessi di Scrittura

  • Tu non puoi inviare nuove discussioni
  • Tu non puoi inviare risposte
  • Tu non puoi inviare allegati
  • Tu non puoi modificare i tuoi messaggi
  •