Forum Discussion
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...
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 🙂
Fowmy
Super User
Super UserAnonymous
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 🙂
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.