I have a view and I want to displays as
Title Office PC Name
Adobe Acrobat DHKL DHKLX2001
DHKLT6001
DHS DHST61001
DHST41001
DHSD41001
DHP DHPD41001
DHPX30001
Under the PC Name column, I have this formula ->
@If(NLinstallOff_1="DHKL";
NLinstallP
C_1;NLinst
allOff_2="
DHPG";NLin
stallPC_2;
NLinstallO
ff="DHS";N
LinstallPC
;"")
but it does not display the above view as what I want. Instead it displays as
Title Office PC Name
Adobe Acrobat DHKL DHKLX2001
DHS DHKLX2001
DHP DHKLX2001
Is there anything wrong with my formula?
Please advise.
Thank you
Start Free Trial