Month Formula

Hi Friends,

I have a list of Fruits and the month that is sold.

Now someone has entered the month in TEXT format 1,2,3,..., 11,12.

I want it to be Jan, Feb, Mar,...,Nov, Dec.

Writing IF-ELSE is a tedious one. I was trying it in that way.

Can you please highlight some easy way.

Tags

Modeling

Calculation Functions

Data Integration

Accepted answers

Hi,

Create a new line item in text format, Use NAME function to convert list format to text format.

Month Alpha Text = NAME(Month Alpha)

~Vignesh M

HI@Sravan_Kumar

Yes, like @VIGNESH.M say

You just need create a new line item and write formula NAME(line item Month alpha)

Regards,

All comments

Hi @Sravan_Kumar

First you can create custom month and give code 1 to 12

and then in the module you can use format list(Custom Month) to line item Month in Alphabet and then you need to use formula finditem

regards,

Panji

Thank You Panji for taking your precious time to help.

Please tell me, using this I get the output in List format.

But I want it in Text format.

Can you kindly show me the process.

Hi,

Create a new line item in text format, Use NAME function to convert list format to text format.

Month Alpha Text = NAME(Month Alpha)

~Vignesh M

HI@Sravan_Kumar

Yes, like @VIGNESH.M say

You just need create a new line item and write formula NAME(line item Month alpha)

Regards,

Quick Links

Can you help?

Unanswered questions

Dimensionality - Formula Help
I have a Price module where customers are ranked based on their unit prices. I also have a Comparison module, where I want to display the names and unit prices of top-ranked customers for comparison. The model includes a Customers list. In the Comparison module, I want to write formulas to bring in the customer names and…
Can there be a duplication in Process ID's
Can there be a duplication in Process ID's
Using Polaris and Classic
Client has spoke models built in Classic and now considering building Data Hub in Polaris in order to deal with sparsity. On the surface this seem possible but likely a bad idea. Has anyone done anything similar to this? Specifically, what did you have to do to ensure that data was compatible? Any thoughts or suggestions…