Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Conditional based output

Hello everyone,

 

I am trying to calculate output column. Can anyone help me here?

 

Output = If Type = "Financial Value" and Financial date =< Today then print Realized column value to the output column else blank.

 

Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    You can use the following code as a new column:

    New Column =
IF (
    Table[Type] = "Financial Value"
        && Table[Financial Date] <= TODAY (),
    Table[Realized Value],
    BLANK ()
)

    ________________________

    If my answer was helpful, please click Accept it as the solution to help other members find it useful

    Click on the Thumbs-Up icon if you like this reply 🙂


    Website YouTube  LinkedIn

5 Replies

  • Mikelytics's avatar
    Mikelytics
    Resident Rockstar
    5 years ago

    Hi Schree185, 

     

    The following formula should work. 

     

    Output = IF(AND('Table'[Type]="Financial Value",'Table'[Financial Date]<= TODAY()),'Table'[Realized Value],BLANK())

     

     

    But one thing. In your picture one time the output value was taken for a row with "Saving Value". Is that right? If yes then you may have to adjust the rule.

     

    Best regards

    Mikelytics

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I took Saving value by mistake. I am sorry for tht.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Mikelytics Hi,

       

      I want to add one more condition . Can you help me with this.

      Output = If Type = "Financial Value" and Financial date =< Today then print Realized column value * "allocation percetange" to the output column else blank.

       

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Anonymous 

    You can use the following code as a new column:

    New Column =
IF (
    Table[Type] = "Financial Value"
        && Table[Financial Date] <= TODAY (),
    Table[Realized Value],
    BLANK ()
)

    ________________________

    If my answer was helpful, please click Accept it as the solution to help other members find it useful

    Click on the Thumbs-Up icon if you like this reply 🙂


    Website YouTube  LinkedIn

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi,

      I want to add one more condition 

      Output = If Type = "Financial Value" and Financial date =< Today then print Realized column value * "allocation percetange" to the output column else blank.