I am trying to use the “show if” for a virtual column but my expression is not working. Meaning it NEVER shows anything regardless if it should or not.
I want the expression to ONLY show if:
Date = today
Industrial DSO (decimal type) > PMI DSO (decimal type)
I am using this expression but something isn’t correct:
IFS(
AND(
[Date] = TODAY(),
[Todays Tiger Industrial DSO] > [Todays Tiger PMI DSO]
),TRUE
)
Hello
I’m not sure what you want, since you didn’t leave more precise information at least for me
Try this
IFS(
[Date] = TODAY(),
[Todays Tiger Industrial DSO] > [Todays Tiger PMI DSO],
TRUE,
FALSE
)
AND(
[Date] = TODAY(),
[Todays Tiger Industrial DSO] > [Todays Tiger PMI DSO]
)
I am sorry.
Here is the Virtual Column I created:
[Todays Tiger Industrial DSO] and [Todays Tiger PMI DSO] are BOTH Virtual columns.
[Todays Tiger Industrial DSO] = MIN(SELECT(DSO for all divisions[DSO],
AND(
[Date] = TODAY(),
[Division]= “Tiger Industrial”
)
)
)
[Todays Tiger PMI DSO] = MIN(SELECT(DSO for all divisions[DSO],
AND(
[Date] = TODAY(),
[Division] = “PMI Tiger”
)
)
)
The table for this is:
Does this info help?
I am sorry. That did not work.
Here is the Virtual Column I created:
[Todays Tiger Industrial DSO] and [Todays Tiger PMI DSO] are BOTH Virtual columns.
[Todays Tiger Industrial DSO] = MIN(SELECT(DSO for all divisions[DSO],
AND(
[Date] = TODAY(),
[Division]= “Tiger Industrial”
)
)
)
[Todays Tiger PMI DSO] = MIN(SELECT(DSO for all divisions[DSO],
AND(
[Date] = TODAY(),
[Division] = “PMI Tiger”
)
)
)
The table for this is:
Does this info help?
