Rounddown

[dstout]

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!!

[Greg_Deckler]

@dstout It means your [Wkstn] column is text and not numeric.

[dstout]

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 again

[Greg_Deckler · Accepted solution]

@dstout Would have to see some sample data. Do you mean like:

ROUNDDOWN((COUNT([Wkstn])*1.15),0)

[dstout]

Fixed, thank you!!