Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Maybe, somebody faced this problem and could help me :-).
I created the calculated column. After the receiving the results, I need remove "Null"s
"Expressions" returns me the correct results, but impossible remove Null values in model
Calculated dimension, where Null remove is possible, - presents not correct results .
my calculation is:
=if (T_Number = Max_T_Number or (IsNull (T_Number) and Qty_On_Hand > 0.1 ), 'New', Null())
Number | T_Number | Max_T_Number | Expressions | Calculated dimension | Qty_On_Hand |
ABC1 |
|
| New |
| 1 |
ABC2 | T119565 | T119566 | New | New |
|
ABC3 |
|
| New |
| 1 |
ABC4 | T119568 | T119568 | New | New |
|
ABC5 |
|
|
|
|
|
thank you!
Not entirely sure I understand what are you trying to remove? Would you be able to share a sample?
hi, thank you!
I want to present only data marked as New in "Expressions" column. in Calculated dimension we have a checkbox "Suppress when value is null".
ABC5 should be not presented in a table
I attached a video, that I meant (two columns names are created options -Expressions and Calculated dimension )
@sunny_talwar Some further info posted, sorry notifications seem to still be messing up, have a look when you can.
Cheers,
Brett