Forum Discussion

Yuiitsu's avatar
Yuiitsu
Icon for Helper V rankHelper V
3 years ago

Power KPI 2.0 KPI indicator index

Hi,

 

I am currently using the Power KPI 2.0 to create the graph below.

The graph is created from 2 different tables: Finance data and Budget.

I want to add in the KPI indicator index so I am trying to create a column whereby 

if

Selling Price < Budget = 1

Selling Price = Budget = 2

Selling Price > Budget = 3

 

Please advise how to create such column/table?

Thank you!

 

2 Replies

    • Yuiitsu's avatar
      Yuiitsu
      Icon for Helper V rankHelper V

      Thank for your reply!

       

      However I do not see anything inside that link that is relevant to my question.

      I am looking for a way to create a custom column that return the result below:

      Switch(

      Selling Price < Budget, 1

      Selling Price = Budget, 2

      Selling Price > Budget, 3

       

      The problem i facing now is the 2 columns are from different tables.