Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Creating columns filtering on another

Hi, I have tried a few of the other tips on here to help me with this, however I cannot get them to work, and I'm sure it should be so simple!   I have 2 columns of data: - 'BaselineNumber' - whi...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , You have two to create 10 columns like

    B0 = if([BaselineNumber] =0 ,[ProjectBaselineFinishDate], blank())

     

    B1 = if([BaselineNumber] =1 ,[ProjectBaselineFinishDate], blank())

     

    Or in visual you can use Matrix

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , You have two to create 10 columns like

B0 = if([BaselineNumber] =0 ,[ProjectBaselineFinishDate], blank())

 

B1 = if([BaselineNumber] =1 ,[ProjectBaselineFinishDate], blank())

 

Or in visual you can use Matrix

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks amitchandak , I'll give this a go and will accept as solution if all good.

    Appreciate your time.

    Rich