Forum Discussion
Rounddown
I have set up a table in PBI. I need to add a column (right click New column) with the following excel command =Rounddown((B2*1.15),0) I have replaced the B2 with the column name being Wkstn (should be count of wkstn but that didn't come up as an option) so on the line I now have:
1 Capacity at 1:15 flex rate = ROUNDDOWN(([Wkstn]*1.15),0)
I come up with the error Cannot convert '1-S-58' of tpe Text to type Number.
I have no idea what this means or where I have gone wrong, would someone please advise? I am very new to PBI.
Thank you so much!!
dstout Would have to see some sample data. Do you mean like:
ROUNDDOWN((COUNT([Wkstn])*1.15),0)
4 Replies
dstout It means your [Wkstn] column is text and not numeric.
Thank you Greg. Okay so the wkstn heading is in text but the details are the count of the wkstn's so they are numerical. Do you know how I may be overcome this?
Thank you againdstout Would have to see some sample data. Do you mean like:
ROUNDDOWN((COUNT([Wkstn])*1.15),0)
