Good day
I have a SQL table called "ZHA_IND", with a column name called "GSART". Under column GSART I have records that contain "33L", "33A","33B","33I","33K","33D" and "33C") which I want to filter on. After filtering, I want to SUM all the extracted items under the "EXPOSURE" column). I have a variable declared for the record called varBPRecord. This is my formula (but I know it is totally wrong and it also gives me a Delegation error):
Sum(Filter(ZHA_IND,varBPRecord.GSART="33L",varBPRecord.GSART="33A",varBPRecord.GSART="33B", varBPRecord.GSART="33I",varBPRecord.GSART="33K",varBPRecord.GSART="33D",varBPRecord.GSART="33C"),ThisItem.EXPOSURE)
Can you please assist me with the correct formula? I am just totally braindead this morning
Thank you kindly