Currency Data Type Issue

Currency Data Type Issue

Hi,

I'm running into an issue with the currency data type conversion with the pipeline tool inside Zoho Analytics.

Basically, when the table is added to the pipeline, the columns with currency data type will be converted to text type. I assume it's because there's a currency symbol in the values. Originally, the currency is Japanese Yen "¥", because that's our local.

I tried various ways to change the data type but they all failed.

- Converting the data type directly to currency results in invalid data.
- Removing "¥" symbol and thousand comma separators, then changing data type to number, then changing data type to currency results in invalid data.
- Removing "¥" symbol and thousand comma separators, then changing data type to number, then saving an output table, then changing the data type to currency in the exported table will work but the currency is Dollar "$" instead of Yen but I couldn't find a way to change that.

Is it something impossible to achieve with the pipeline tool or would that work by creating a query table instead? The pipeline tool is supposed to allow to change the data type in currency but it always give me a 0% match.

Thanks
    • Sticky Posts

    • What’s New in Zoho Analytics – September 2025

      Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded
    • Announcing Agentic AI - Ask Zia!

      We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.
    • Invitation-Based User Access in Zoho Analytics

      Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security
    • Zoholics Europe 2025: Your Ultimate Data Analysis (Zoho Analytics) Workshop Experience

      Why should you attend? This year, Zoholics Europe 2025 is putting data analysis centre stage. With a dedicated workshop designed to answer all your data-related questions, you’ll gain practical skills, real-time solutions, and expert insights that you
    • [Webinar] Evolving BI & Analytics in the Age of AI

      Artificial intelligence is redefining how data is collected, analyzed, and leveraged across industries. As businesses strive to become more agile and insight-driven, traditional BI and analytics must transform to meet new demands. AI-first organizations