Explore our best practices, forums, and more for all areas of the Anaplan platform.
Improve your knowledge of Anaplan with in-person and virtual training options.
Join the ranks of top model builders with our elite recognition program.
See what's new and exciting with Anaplan and our Community.
Suggest and vote on ideas to improve your Anaplan experience.
Being a Anaplan builder, I would like to extend TEXT() functionality to work similarly to excel function, exactly:
1) Follow different format conversions
2) Follow preset patterns, to exclude unexpected text from numbers results etc.
Example of wrong work to be prevented with new functionality:
Text(1504322.40)= 1504322.4 - ok
Text(15751942)= 15751942 - ok
Text(15751942.50)= 1.57519425E7 - wrong
With same functionality, as in Excel, it would be possible to use preset patterns to exclude such cases. Examples from original Excel TEXT() function description (taken from support.office.com) :
Currency with a thousands separator and 2 decimals, like $1,234.57. Note that Excel rounds the value to 2 decimal places.
Today’s date in MM/DD/YY format, like 03/14/12
Today’s day of the week, like Monday
Current time, like 1:29 PM
Percentage, like 28.5%
=TEXT(4.34 ,"# ?/?")
Fraction, like 4 1/3
Fraction, like 1/3. Note this uses the TRIM function to remove the leading space with a decimal value.
Scientific notation, like 1.22E+07
Special (Phone number), like (123) 456-7898
Add leading zeros (0), like 0001234
=TEXT(123456,"##0° 00' 00''")
Custom - Latitude/Longitude
Benefit of the change: flexible TEXT() function with ability to prevent unexpected results.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.