Forum Discussion
dstout
4 years agoNew Member
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 (shoul...
- 4 years ago
dstout Would have to see some sample data. Do you mean like:
ROUNDDOWN((COUNT([Wkstn])*1.15),0)
Greg_Deckler
4 years agoCommunity Champion
dstout It means your [Wkstn] column is text and not numeric.
dstout
4 years agoNew Member
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_Deckler4 years agoCommunity Champion
dstout Would have to see some sample data. Do you mean like:
ROUNDDOWN((COUNT([Wkstn])*1.15),0)
- dstout4 years agoNew Member
Fixed, thank you!!