6 Replies Latest reply on Jan 20, 2017 3:04 AM by Richard Silvekroon

    Formula for differentiate Male/ Female based on ID

    Richard Silvekroon

      Hi,

       

      I'm new to tableau and to this forum and was wondering if someone who has more experience using formulas in tableau would be able to give me a few pointers.

       

      I wish to create a filter where I can differentiate between Male / Female, I have a data source with personal numbers (similar to social security numbers) in this format: 8406083936 where the 9th number indicate male or female. Odd number = male, even number= female. In Excel I would use something like this:

       

      =IF(ISODD(MID(A1;8;1));"Male";"Female")

       

      but I'm unfamiliar with the way Tableau formulas are structured and work and I have no developer background so my capacity is a bit limited in this regard. I would greatly appreciate any assist in this matter.