Hello Dear All,

I am doing an analyze for a supplier companys inventory. The data-set is like this in the image below.

Screenshot 2020-01-07 at 14.08.041495829 62.5 KB

What I want to do is to determine the valuable products according to frequency and price rank. So, for this purpose I firstly aggregate the all products with price rank and created new column represent the frequency counted.

Screenshot 2020-01-07 at 14.56.44435820 18.6 KB

And frequency is calculated with this KPI: COUNT_TABLE(PM_Last.csv_CASES)

And now I just want to apply a manual RFM algorithm to determine most valuable products. So, I need to use the values of this two column and create a monetary value in another column. For this, I just need to multiply the 2 column, such as the formulation that I tried

COUNT_TABLE(PM_Last.csv_CASES) * PM_Last.csv.BuyPriceRank

But, I receive this error message :

Screenshot 2020-01-07 at 14.12.45786133 9.82 KB

I think, what I want to do is not complex but I couldnt find a way to use aggregation in a basic formulation to show in another column in the same table.

I would really appreciate if someone could give some advice.

Thank you all and have a happy working days.