This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
Product Feedback Forum
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Community
- Product Feedback
- Formula - Having string functions / Applicable to ...
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Status:
Needs Votes & Comments
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Hello,
I would like to porpose the following regarding formulas :
- beeing able to defined formulas in the line or column section (for widget "pivot table"). Functions like SUBSTRING, LEFT, RIGHT, or CONCAT in order to reformat the content of a dimension also beeing able to use CASE function (to build buckets).
- beeing able to use string function to define conditions to apply to a dimension.
ie :
CASE [Type]
WHEN "A" THEN price * 09
WHEN "B" THEN price * 08
ELSE price
END
Thank you
See more ideas labeled with:
1 Comment
