PDA

View Full Version : 2014 Schedules - Calculated Value does not have "Count" in the list of fields



Bluefairy
2013-08-29, 06:10 AM
I'm trying to input the price for the number of fixtures in my schedule. I added "count" in the fields. However, when I try to create a calculated value, I dont see "count" to be inputted into the formula. Why wouldnt "count" be listed for the formula??

jsteinhauer
2013-08-29, 04:03 PM
Because you put in the price per unit, then calculate the totals in the footer. If you don't itemize every instance, you should be given the total for each line item.

I hope this helps,
Jeff S.

Bluefairy
2013-08-29, 04:42 PM
I guess I'm not following. I still dont see "count" to input into the formulas. I did not itemize every instance. Is there a work around if "count" cant be used in the formulas?

CADastrophe
2013-08-29, 06:05 PM
If you want to show the total cost per line, go to the Formatting tab under Schedule Properties. Select the appropriate field from the list on the left, and then enable the option 'Calculate Totals'. Note that this option is only available to fields which can be totaled, for instance, it won't be available for Text type fields.

If you want to have a separate field for 'Total Cost' per line, create a Calculated Value with the formula: "Cost", and follow the above steps with this instead.