Forum Discussion
Change Format on Measure Formula Result
Hi
How do i Remove the .00 from the below measure result?
Hmm, I would say just define the measure as a whole number in the measure formatting, but if you've got the possibility of it being text, then I guess that wouldn't work? Not sure why it's displaying .00 as that makes no sense in a datediff context, unless it defaults anything to having two decimal places. Try going INT(DATEDIFF([Today],[Ins Exp Date],day)) or TRUNC(DATEDIFF([Today],[Ins Exp Date],day)) perhaps?
2 Replies
Hmm, I would say just define the measure as a whole number in the measure formatting, but if you've got the possibility of it being text, then I guess that wouldn't work? Not sure why it's displaying .00 as that makes no sense in a datediff context, unless it defaults anything to having two decimal places. Try going INT(DATEDIFF([Today],[Ins Exp Date],day)) or TRUNC(DATEDIFF([Today],[Ins Exp Date],day)) perhaps?
Thanks J - the INT function at the start of the datediff formula done the trick
