Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
my table looks like below
rep ID |column name | column value | total value
10002 sales region france 100
10004 sales teritory | le pont | 200
10002 sales office avenue ,3 | 300
10004 sales region italy | 160
10002 sales office | 300
now i need a condition in the script
if |column name is sales region and the value of sales office is blank or null ) as a [sales reps france]
May be this?
If([column name] = 'sales region' and IsNull([column value]), 1,0) as [sales reps france]
How you are checking sales region and the sales office in same column, please elaborate more.
if you Need to check for null and blanks i would recommend to use this:
if(COLUMN_NAME='sales region' AND len(trim(COLUMN_NAME))>0, 'NON_BLANK_OR_NULL', 'BLANK_OR_NULL') as CHECK_COLUMN_NAME
hi all,
iam basically checking multiple columns..
that is if column name is sales region and if the column name is sales office and the column value of sales office is blank or null then [sales reps france]
Try to respond all
Anyway, from this case you can use like
If(Match([column name], 'sales region', 'sales office') and IsNull([column value]), 1,0) as [sales reps france]