I am trying to use this formula. but I am getting error.
if [Account Group] = "CAPL CE"
or
"COMPTR"
or
"SW SEH"
Then [Fixed Asset After Adjustment] else 0
Can someone please help me to fix this formula?
Solved! Go to Solution.
if [Account Group] IN ("CAPL CE", "COMPTR", "SW SEH")
Then [Fixed Asset After Adjustment] else 0 ENDIF
Hi @rrahu07
Formula should be
if [Account Group] In ("CAPL CE","COMPTR","SW SEH")
Then [Fixed Asset After Adjustment]
Else 0 Endif
Hope this helps : )
YOU ARE AMAZING!!! Thanks.
Happy to help : ) @rrahu07
Cheers and have a nice day!