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 outpu...
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

Mikelytics's avatar
Mikelytics
Icon for Resident Rockstar rankResident 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.