Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Multiple Criteria IF Formula

Hi Experts   How would you do the following.  If PrimaryYearstoOUtcome is 5.0 then 5.0 if PrimaryYearstoOUtcome is 5.1 and we have a 5.0 (in data set as shown) then leave 5.1 as 5.1   if(STEMBRA...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi

 

when i put the measure into a table i am not getting the correct values.... let me share a sample file you'll see the formula is adding up all the values in the primaryyearsto out from 0.0 to 1.0 as opposed to just show the values at data point 0, 1, 2, 3, 4, and so hence my first formula and or you could say we are subtracting the data points as we move from 0.0 year onwards....

ref to tab Duplicate of (Kaplan-Meier)

and table Stembrandyears. 

 

i am trying to get the to the right as produce by R.

https://www.dropbox.com/s/s4wj3qzpblasw66/Kaplan_Miers_v1.2.pbix?dl=0

 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

I think you are referring to this. What are the values expected in this table

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Amitchandak

     

    I am referring to that table i am expecting the values as shown in the R Table to the left. See Below image 

     

     

     

     

     

     

    i.e. 0 years is 664 and 1 is 656 and so on....

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI AmitChandak

     

    any luck with the table as discussed