Fill In The Blank

[pandreozzi]

I am trying to create an expression within a dimension that populates a cell in a chart.

The expression should look at the "Resolution Status" and the "Record Class"

The "Record Type" field should have values there where values are not on the spreadsheet that is used as a source and need to be populated with either the name "Asset" or "Site"

I have tried different expressions that seem to be ok in syntax but do not fill in the empty fields in the Record Type column.

What I am trying to do is this:

If([Resoluttion Status] = 'NEW" and [Record Class]='Router,1,0 [Record Type]='Asset')

This maybe wrong above but I a trying to fill in the - with Asset or Site

Any help is appreciated.

Thanks !!!

[pandreozzi]

Prashant, your example above works but changes the text 'Asset' to the text 'Router' where true. What I am trying to do is to replace the hyphen with the word Asset. I am pasting my example.

Currently [Record Type] has a value of -

=if([Resolution Status]='NEW' and [Record Class]='Router','[Record Type],'Asset')

[PrashantSangle]

There is syntax error always check bracket , single quote

Try below

=if([Resolution Status]='NEW' and [Record Class]='Router',[Record Type],'Asset')

[pandreozzi]

I did realize that syntax error and corrected it however the results are still the same. I am looking into using the "If Match" in my expression also. I will keep posting results and your assistance is much appreciated.