Delete Rows with 0 in a calculated column

[eric2357]

Hello,

I would like to delete rows with 0 in a calculated column. In one model, I have created two identical calculated columns, and for one of them, I have the opportunity to delete these rows, for the other column it is not possible.

Does someone have an explanation for this?

I tried it with a different model, and it didn't work in any calculated column.

I will upload some screenshots.

Thank you!

Kind regards,
Eric

delete0-1.png

delete0-2.png

[eric2357]

nikhil.anand

Do you have other suggestions how I can solve this issue? If it doesn't work with calculated columns?

I would like to delete rows that have zeros for every measure (in the real model, there are many measures).

My current approach is to duplicate every column, concatenate these copies, and then I can delete rows with the value "0 0 0 ...". But this is very laborious.

Do you have any suggestions?

Kind regards,

Eric

[eric2357]

Hi Nikhil,

thank you for your fast response.

Thats too bad! Yes, within that model, I could create many calculated columns that worked equally as "calculated column 5". But in other models, it was not possible.

Kind regards,

Eric

[N1kh1l]

eric2357

eric2357In calculated column you cannot delete rows, you can only delete the whole column. Calculated Column 5 some how is not getting recognized as calculated ( without Fx). Were you able to create more such column ( without fx) in another model or within the same model

Nikhil