Generate Report type error


#1

I think this image explains it far better then I can, but I have 2 fields ( board length ) and ( Board price ) where cost per foot is computed, and then from that total cost is computed.
IF i don’t use the DOLLAR(value,decimal) setting it works but the price is displayed wrong in the report…
What in the world am I doing wrong?


#2

The report is “seeing” the 220.66 as inches and convert to a fraction. try changing the cell in the attribute zcostofwall to text. you need to add “$” & to the start of the formula


#3

it is…


#4

try the “$” & in front and change display to text? plus default text should be text


#5

wont that mess up the length calculations for the studs and such?


#6

I believe all cell are in fact strings, they are then evaluated to a number. the output is then treated / converted to the type.


#7

oh, so your saying go ahead and change board length to text / text? not text/inches?


#8

yes, you always can undo

“i buy @ $” & 7 => “i buy @ $7”


#9

leave the board length as inches


#10

we’re getting there… i can have cost / ft display $ OR estimate but not both, if both are text.





I really appreciate all your help… would it be easier if I just gave you the .skp file?


#11

I think i figured a work around… i created another field and used DOLLAR(ycostperfoot,3) and using that as a “display” & the Y one as the math…