SAC Funtion not working

[former_member657015]

Hi Team

I need to remove data where description like "20-" is mentioned.

For which, I am creating dimension calculated field and writing formula which gives me err msg like below:

Formula could not be computed: Function "NOT" is not allowed as the top-level function in a Calculated Dimension. Try rewriting the formula.

Please suggest.

Thanks

Neha

[former_member657015]

Thanks Debjit !!

But I need to remove the complete row.

Above code will leave the record as blank only instead of removing the row.

Please help.

Regards

Neha

[former_member657015]

capture.pngHi Debjit

I have tried the same option also. Please find below:

Here the list is showing only 100 items which should be more than 400 items in it. Please let me know if I can increase values of the list. So that my issue will be resolved.

Thanks

Neha

[DebjitSingha · Accepted solution]

Hello nehaverma,

Some sub functions are not allowed in nested format (combination with other functions). Not is among one of them.

You should be able to use "Like" function for your requirement. Here is an example-

Say you want to carte calculated country column and replace country start with "Can" as blank.

Use combination of "If" and "Like" function with "Can.*" for pattern check. Note: add ".*" for pattern check.

Canada is replaced with no value.

Hope this helps. Let us know if you have any query around this topic.

Viewers/ readers if you find above information helpful, feel free to vote ( arrows on the left side)

- Debjit