Variance Report

#1

Currently, on our monthly Variance reports, it gives the name of the account but not the account number. Is there a way to do a 2nd data view that mirrors to give the account number also?
Thanks

#2

To display both account name and key, I clone the column. Then, set one column to name and the other to key.

5 Likes
#3

Hi @laura.washburn - this Help Center Knowledge Base article describes Amy’s suggestion Display Keys and Names on the Report. Hope this helps!

1 Like
#4

I would usually use an Account column and use Key & Name as output.
Add two blank columns beside the same column and split the Key and Name in two column using Left/Substr/Right functions and hide the Key & Name column on report for more cleaner report presentation.

1 Like