Forum Discussion

Amp_'s avatar
Amp_
Frequent Visitor
7 years ago

how to change Column format from duplicated table

Hey Everyone!

 

i would like to ask about matrix table. i want col. to show sum of Vol. fail case in itm_sts_mod but after i made, condition show duplicate table of fail case

In the fail case, You can see itm_sts Col. have 2 status which is Cancelled and NPASS so that's why data show dulipated 

 

= IF(UPPER(v40_report_inq_sts[prc_sts])="NPASS","F3"  <---- this dex is for fail condition

Would you be so kind to solve this problem? Thank you in advance :)

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi buddy,

    I don’t quite get what you’re trying to do here.

    Are you trying to add an extra column in a table to count how many cases has Failed or NPASS as in status? If yes, what is the table structure that you are using and what are the combination you have used to create your matrix “Rows, Columns and Values”? Usually screenshots would do great help with these kinds of scenarios.

    If the above is not useful or you think it is irrelevant perhaps you consider rephrasing your query?

    Kinds regards

    Hicham

    • Amp_'s avatar
      Amp_
      Frequent Visitor
      7 years ago

      Hey Hicham,

       

      I'm trying to add colume to count how many cases has Failed in status

       

      actually i have 3 conditions of fail case 

      inq_itm_sts_mod = IF(UPPER(report[Conditions]) in {"F1","F2","F3"} ,"Fail"
      -----  F1 & F2 :  inq_itm_sts are Cancelled 
      ----- But only F3 : inq_itm_sts have 2 status which is  Cancelled and NPASS (so matrix table show duplicated)
      e.g.
      Conditions = 
      IF(UPPER(report[inq_itm_sts])="Cancelled" && UPPER(report[Cancel_sts])="1" && UPPER(report[prc_sts]) = "PASS" , "F1"
      ,IF(UPPER(report[inq_itm_sts])="Cancelled" && UPPER(report[Cancel_sts])="0" && UPPER(report[prc_sts]) = "PASS" , "F2"
      ,IF(UPPER(report[prc_sts])="NPASS","F3" 
       
      and i created matrix of
      1. Count of ID
      2. Sum Quantity 
      3. measure of Avg. 
       
       

      Regards

      Amp

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Again,

        And please bare with me :)

        Can you please post a screenshot of a table showing the view that you are trying to calculate?

        e.g.:

        I hope this makes sense :)

        Kind regards

        Hicham