I want to know If I can add a conditional formula to total column

Stephen_George · September 13, 2024, 4:46pm

I want to have a column to divide with specific number. refer the image. Like all the numbers to be divided by 300 in this case. i need to define benchmakr from my team.

nauris.malitis · September 16, 2024, 6:55am

Hi @Stephen_George

Welcome to the Community!

You can define a new calculated measure in the Measures dimension with a formula like this:

[Measures].[Issues created] / 300

You can then set the Formatting to Numeric → Decimal or Percentage to reflect the data.

Best regards,
Nauris

Stephen_George · October 2, 2024, 4:09am

Thank you Nauris. This worked.