Formula - Having string functions / Applicable to dimensions | Product Feedback Forum

fschleich · 2024-01-15T13:14:36.959000Z

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 * 09WHEN "B" THEN price * 08ELSE priceENDThank you

MoreDiscussions

Formula - Having string functions / Applicable to dimensions | Product Feedback Forum | Sisense Community