Write, Bureaucrats, Administrators
4,332
edits
mNo edit summary |
mNo edit summary |
||
Line 118: | Line 118: | ||
==== Add Over/Under Calculation ==== | ==== Add Over/Under Calculation ==== | ||
Edit the Library again, and this time add a JavaScript field called Over or Under. | Edit the Library again, and this time add a JavaScript field called Over or Under. An edit card will be displayed for the JavaScript field. | ||
In the script area, where the watermark JavaScript is filled in, press the + Field button and select the Actual field. You'll see, inserted for you "field('Actual')" (the double-errors are mine). Type a minis sign ("-"), then press + Field again and this time select the Estimate field. | |||
That's it for the script; now just display in the list as Entry Status, and your done. Tasks that are under budget well show a negative number, on budget a zero, and over budget a positive number. I suggest setting the field to One row with prev to keep all estimates on the left and actuals on the right. | |||
Of course, with grouping, you can see the variance by phase or by contractor and overall st the bottom. | |||
[[Category:Tutorial]] | [[Category:Tutorial]] |