Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Divide value by duration gives wrong result

I do have a table with a start and end date of a project and want to divide a total value by the project duration.   I am using the following column calculations:   duration = Table[end]-Table[st...
Need Help
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

Change the formating of the Value_Daily from Auto to 0

Anonymous's avatar
Anonymous
Not applicable
6 years ago

aj1973

 

Not exactly. This might be true for the first number but the second should actually be 60 and not 61.

My problem is that both the duration and the daily value are calculated correctly because when I multiply those two numbers, I get the exact value I want.

However, it does not seem to be displayed the right way in the chart.

 

parry2k amitchandak could you please have a look at the file I just uploaded? Thanks

 

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    Anonymous I'm actually not sure what the underline issue is, you are dividing value by days and it is returning the decimal number and then taking the sum, so what is the issue? Maybe put data for a month in an excel sheet and explain what is your expected result and what you think is wrong. Your problem statement is not clear to me