Show evenly divisible amounts

building reports desktopintelligence
1

I’m using BO Version 5.1.6 Csp_753 and I have a measure object called Transaction Amount. I’m taking that measure object and dividing it by 1000. What I want to be able to do is to show the rows of data that are evenly divisible by that amount but I can’t seem to find a function that will allow me to do that. Any suggestions?

Here are a couple of examples:

Transaction Amount = 540,000.00
Divided by 1000 = 540.00 (meets criteria for being evenly divisible by 1000)

Transaction Amount = 100,000.00
Divided by 1000 = 1000.00 (meets criteria for being evenly divisible by 1000)

Transaction Amount = 2,092,433.00
Divided by 1000 = 2092.43 (does not meet criteria for being evenly divisible by 1000)

In other words, I want to be able to filter on the rows of data where the decimal point is .00.

Lisa Rose :us: (BOB member since 2002-08-28)

2

Hi,

create a new filter applied on your table. The filter will be defined as:

=Mod(<Transaction Amount)> ,1000) = 0

Marek Chladny :slovakia: (BOB member since 2003-11-27)