3 Replies Latest reply on Sep 3, 2018 4:15 PM by Ritesh Bisht

# Changing the scale

Hi everyone,

I'm stuck with a problem and need help.

I have as input two variable, themes and the search volume to the theme.

The data looks like this:

I want to convert the data now so that the highest value per topic gets the value 100 and the lowest value gets the 0.

So I would like to apply the following formula per topic:

(Volume - Min(Volume))/((Max(Volume)-Min(Volume))

Unfortunately it doesn´t work or I don´t find the right solution -  any help is more than welcome

Lars

• ###### 1. Re: Changing the scale

Hi Lars,

Do you mean like this ?

Step 1 MAX VOL

{ FIXED [Topic] : MAX([Volume]) }

Step 2 --MIN VOL

{ FIXED [Topic] : MIN([Volume]) }

Step 3

0 0r 1

if [Volume]=[Max Vol] then 1

ELSEIF  [Volume]=[Min Vol (copy)] then 0

END

Please find the attachment .as well.

Thanks,

Ritesh

1 of 1 people found this helpful
• ###### 2. Re: Changing the scale

Hey,

thank you so much! Works perfectly!

1 of 2 people found this helpful
• ###### 3. Re: Changing the scale

Hi Lars,