I don't see any function in Tableau 9.2 called Floor ().
Are you using extracted data or a live connection? FLOOR should be available in 9.x and above.
If you have a live connection then I would assume it's not supported in your data source.
Alternatively, you can use this as a calc (borrowed from Jonathon Drummey) to get FLOOR
IF [Value]==INT([Value]) THEN
ELSEIF [Value]<0 THEN
It did not work......
IF [Actual % of Baseline Remaining]==INT ([Actual % of Baseline Remaining])
THEN [Actual % of Baseline Remaining]
ELSEIF [Actual % of Baseline Remaining] <0
THEN INT([Actual % of Baseline Remaining]-1)
ELSE INT([Actual % of Baseline Remaining])
Actual % Baseline Remaining
If [Month Type] = 'Actual' Then [Baseline Remaining %] END
(([Gc Tot]+[Gleg Tot])/[Gbase Tot])*100
Upload a packaged workbook so we can see what is actually occurring then.
How about simply trying INT()? What results does it give you?
Calculation 1 and 2 both works. I had to change them to ATTR. Which should I use 1 or 2 ?
Use the simplest that is working...either FLOOR(), INT() or the IF statement.
Sorry, results are not 100% correct. There is still some difference.
Sorry, I think, I did not tell it correctly
I have the numbers like this: 64.99, 50.65, 43.86, 10.91, 8.62, 0.23
But, I want it to look like: 65, 51, 44, 11, 9, 1
0.23 should be 1, how do I write the rule ?
SO maybe :
ROUND(if [Value] < 1 then 1 else [Value] end,0)
I haven't tested this in Tableau though.
Why don't use the Default Properties>Number format>Number(Custom) and set the Decimal places into zero, then the data will be showed just like the round function afterwards.
Jack, it should always be "Rounded Up" except anything more than 100 will be 100.
Example: 50.11 ----> 51,