The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

i need to get the differences between expenses and revenue in percentage (%).

ColdlenColdlen Member Posts: 2 Learner I
edited December 2019 in Help


How i perform my function descriptions in generate attributes to get my differences between total expenses and total revenue in percentage form (%)?
tq in advance, i m in hurry


Answers

  • kaymankayman Member Posts: 662 Unicorn
    Pivot both tables first so you get 3 columns (Criteria / Year / Value), then join both tables on year, and then use the generate new attribute operator to calculate using the Value of table 1 and table 2
  • Telcontar120Telcontar120 RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 Unicorn
    Also be sure to use square brackets to enclose your attribute names since they look like they are numbers, which means RapidMiner will otherwise interpret them as numbers and not attribute references.
    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
Sign In or Register to comment.