Hello Dear All,
I am doing an analyze for a supplier company’s inventory. The data-set is like this in the image below.
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.
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 :
I think, what I want to do is not complex but I couldn’t 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.