Hi, I've just started SSR2005 this week, and I'm unsure of how to round down a number in my expression. My code is:
=reportitems!TotalSeconds.Value Mod 60
Basically, the total seconds could be coming in as 74.564, but I want the remainding seconds after dividing by 60. In other words, I would want to return 14, rather than 14.564. I have noticed that if I put N0 in the format, it rounds it up. Also I'm not sure how to use the round function, and it would appear to round up (?).
Can somebody help please?
Thanks, Dan.
Hello Dan,
Can you try this and see if it fixes your issue:
=Floor(reportitems!TotalSeconds.Value Mod 60)
Hope this helps.
Jarret
|||Works perfectly, thanks very much!
没有评论:
发表评论