You can follow with what's been done in the attached 2018.3 workbook (screenshot below) of a CASE statement that is using Roman Numeral 1 - 1000. More than 1000 you'll need to do yourself . Hope it helps. If it does, please mark this response as correct, Thx, Don
Roman Numeral Conversion.twbx 43.4 KB
OK, now I'm fascinated to know what project compelled you to do a Roman Numeral conversion template...
No real project need, this was just an easy one for me to do as I'd had this old table of pre-existing roman numeral data to use from way back when I was probably doing some research project in my 30's.
I used Custom Numbering in Excel to format/wrap 'quotes' for the WHEN part using \'@\' then just copied WHEN and THEN on separate columns down their respective columns and then copied/pasted the whole thing into a calc. Added in the CASE piece before and added an END. Took all of 5 minutes .
But, now if someone does have a use case scenario...like Rajesh...well, let's see how it ends up being applied. Great question tho'! I often wonder how some of my 'helpfulness' and of course yours and everyone else's gets applied to real-world use cases...
Thank you for your input. Yes, this is indeed right way.
This was one way I already thought about. but end limit of roman numeral may be not limited (I wanted it to be dynamic).
So I have created calculated field to convert roman numeral to integer if it is less than or equal to 7000.
but i think that is lengthy process.
Please let me know if I am missing some tableau function or rule which can easily help me with out creating calculated field.
Rajesh Ashok Jaiswal
Very cool. I love solutions like this - and you're right, they take on a life of their own.
Great, glad to have helped. If you would, please mark as correct to close thread so others may find it useful in the future. Thx! Don