Forum Discussion

JayRamaswamy's avatar
JayRamaswamy
Copper Contributor
Jun 07, 2020
Solved

Calculated field with a column of string type

Hello

here is my spreadsheet in which I would like to create a calculated field after the GRAND TOTAL column.

 

SourceABC           
ProjectCustSTAT           
RunDate05/05/2020           
             
CORPORATEBY STATUS           
DEPARTMENTSignoff WaitingCompleteHelp DeskIn ProgressCancelledGrand TotalCompleted %     
HR                          91            4,645             79         1,002            9,973         15,79029.42%Calculation should be count(Complete)/Grand Total
SALES                          13            6,595             15             989         14,276         21,88830.13%     
IT                        130            4,600             23         1,142            8,684         14,57931.55%     
SECURITY                            8            1,269               3             248            5,231            6,75918.77%     
QA                          21               562               4             168            1,833            2,58821.72%     
PURCHASE                            7               599               1             389            1,452            2,44824.47%     
MAINTENANCE                  70                24               924            1,0186.88%     
SUPPORT                211                43               610               86424.42%     
BUILDING MAINT                  54                20               448               52210.34%     
GRAND TOTAL                        270         18,605           125         4,025         43,431         66,45628.00%     

 

 

The calculation for the new calculated field is:

        IF STATUS = "COMPLETE" THEN

                   COUNT(STATUS)/Total Number of Records

        END

 

The new calculated field should be shown only if the status = complete.

 

I am experiencing trouble since it's creating the calculated columns to all the columns.

Any help is appreciated.

 

Thank you

Jay

excel
  • JayRamaswamy's avatar
    JayRamaswamy
    Jun 08, 2020

    Hi SergeiBaklan 

     

    Thanks very much. It worked. I wanted to control this measure to only one column.

    I will send the snapshot of my excel after I added measure.

     

    Thank you

    Jay

4 Replies

Resources