Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
5 years ago
Solved

promotion calculation

I have week promosion always going on.

 

I have

 

product     Sale price           Weeky 10% PromotionWeeky 5% Promotion

A

$10no promotion this week9.5
B$1210.811.4
C$15no promotion this weekno promotion this week
D$5No promotion this week4.75
E$201819
F$98.1no promotion this week

 

now I need to make report just to find the list and count

Weeky 10% Promotion,

Weeky 5% Promotion,

and

Product that never has promotion at all (like Product C in table)

 

also this week promotion and last week to compaire

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    abc_777 ,

     

    Countrows(filter(table, Table[Weeky 10% Promotion] <> "no promotion this week"))

     

    Countrows(filter(table, Table[Weeky 5% Promotion] <> "no promotion this week"))

     

    Countrows(filter(table, Table[Weeky 10% Promotion] <> "no promotion this week" && Table[Weeky 5% Promotion] <> "no promotion this week" ))

     

     

    Plot with product in visual; to get the products

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    abc_777 ,

     

    Countrows(filter(table, Table[Weeky 10% Promotion] <> "no promotion this week"))

     

    Countrows(filter(table, Table[Weeky 5% Promotion] <> "no promotion this week"))

     

    Countrows(filter(table, Table[Weeky 10% Promotion] <> "no promotion this week" && Table[Weeky 5% Promotion] <> "no promotion this week" ))

     

     

    Plot with product in visual; to get the products