1 of 1 people found this helpful
Seems to me you would need a looping construct, which Tableau doesn't do.
But I can say this:
IF ( INT([A]/[B])*[B] ) = ([A]/[B])*[B]
then [B] is a valid divisor.
What you would do with that ... I'm not sure. You need to run a loop to test that for all values of [B] from 1 through [A] to get all the possible divisors of [A].
Sounds like a useful feature that Tableau could develop in the future but for now I’ll just have to move on and find another solution for this.
Lots of programming constructs would be useful, but Tableau isn't really written to be a programming tool.
There is an IDEAS forum ( here: Ideas ) where people propose ideas and others can vote them up or down. I have voted up some threads on looping capabilities. Search around in there and add your voice to ideas you like.