Calculating Percentage Change

[Anonymous]

Hi there, 

Does anybody know how to calculate percentage change with text based field e,g (FY17/18, 17/18) ?

I have a field that is a text, and am trying to calculate % change based on it. 

[alexei7]

Hi @Anonymous,

Would you be able to provide some sample data to illustrate what you're trying to do?

Much appreciated

Alex

[Anonymous]

Hi Alex, 

The sample data is above. I am trying to calculate % change using FY field

[pnvinod]

Can you add the % value you are expecting to see

[Anonymous]

Hi there, 

Below is the expected output.

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

If you can't use a date table, I would suggest you add a new table like below.

FY               Index

17/18           1

18/19           2

Then establish relationship. You can get the previous FY easily now.

How can we calculate the % Change? Your sample seems wrong.

Best Regards,

Dale

[Anonymous]

Thank you very much Dale, it worked.

The calculation was just a make up numbers.

Regards