Forum Discussion
Solved
Cell Value Showing "OK"
Hello,
I was wondering if it's possible to have a check figure if the amount equals 0 that it displays "OK" and if it doesn't it says "Check Details". I've tried conditional formatting when the cel...
Yes, but in the U8 you would have to recalculate that Total value, because dynamic calcs don't know anything about columns.
Hey Will,
You can accomplish what you are looking for largely through number format imposed on the target row or column.
Remember that number format has POSITIVE;ZERO;NEGATIVE format handling in both Data Explorer and Excel.
Try using the above as your number format -- this means that you are looking for:
[Check Details];[OK;][Check Details]
This will return "OK" if zero and "Check Details" for all others. One last note of caution, small decimals that round to zero are also regarded as zero in the above format so ensure your Validation Member formula accounts for this. For example, multiply by 100.
Recognize this is a #Hack but probably gets you to what you are looking for without having to use UD8 and calculate.
Cheers,
A.