Skip to main content
Solved

How can I calculate the Share of Product Type for each Delivery Number?In the enclosed screenshot, I'm trying to calculate the yellow column. I tried by using the PU_X functions, also combined with 'DOMAIN_TABLE', but I couldn't get any kind of

  • January 18, 2023
  • 2 replies
  • 13 views
andré.link
Level 3
How can I calculate the Share of Product Type for each Delivery Number? In the enclosed screenshot, I'm trying to calculate the yellow column. I tried by using the PU_X functions, also combined with 'DOMAIN_TABLE', but I couldn't get any kind of result.

Best answer by sree.c

Hi Andre,

 

try this

 

pu_count(DOMAIN_TABLE ( "Table"."Product_type","Table"."Delivery_number"),("Table"."Delivery_number"))

 

/

 

pu_count(domain_table("Table"."Delivery_number"),"Table"."Delivery_number")

1 Attachments

    2 replies

    sree.c
    Level 7
    • sree.c
    • Level 7
    • Answer
    • January 18, 2023

    Hi Andre,

     

    try this

     

    pu_count(DOMAIN_TABLE ( "Table"."Product_type","Table"."Delivery_number"),("Table"."Delivery_number"))

     

    /

     

    pu_count(domain_table("Table"."Delivery_number"),"Table"."Delivery_number")

    andré.link
    Level 3
    • andré.link
    • Author
    • Level 3
    • January 18, 2023

    Works perfectly, thank you!!

    Community Code of ConductAccessibility statement