How to Customize payslip month from numeric to alphabet

Created by Cheng Kah Poh, Modified on Wed, 30 Dec, 2020 at 4:16 PM by QNE Software Sdn bhd

Scenario 

Payslip current view:

After Customized:

 

Solution 

Step 1 - Click Report Files.

 

We can filter payslip

 

 

 

 

 

 

 

Step 2 - After Filter Payslip, point More à then Click Design. 

 

Step 3 – Click Month Field à Click F à Click … 3dot , next to text

 

Step 4 – after Click … 3dot, insert the expression and Click Save.

 

 

Note : Expression as below

Iif([Month] == 1,'January''[Year]'

,Iif([Month] ==2,'February''[Year]'

,Iif([Month] ==3,'March''[Year]'

,iif([Month]==4, 'April''[Year]'

,Iif([Month]==5,'May''[Year]' 

,iif([Month]==6,'June''[Year]'

,Iif([Month]==7,'July''[Year]'

,Iif([Month]==8,'August''[Year]' 

,Iif([Month]==9,'September''[Year]'

,Iif([Month]==10,'October''[Year]'

,Iif([Month]==11,'November''[Year]'

,'December''[Year]'  ) ) ) ) ) ))) ) ) )

 

 

Step 5 – Save the format.

 

 

 

 

 

 

Result:

 




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article