Simplified Set Expression

[suryaa30]

Sum({< Year = {'$(=Max(Year))'}, FK_Service = {'0', '2208', '2214'} >} GrossSales_P_RISK_Monthly)

-

Sum({< Year = {'$(=Max(Year))'}, FK_Service = { '2108'} >} GrossSales_P_RISK_Monthly)

Can someone help me above expression. A-B

[PrashantSangle]

Hi,

try below

Sum({< Year = {'$(=Max(Year))'}, FK_Service = {'0', '2208', '2214'} >- <Year = {'$(=Max(Year))'}, FK_Service = { '2108'}>} GrossSales_P_RISK_Monthly)

[sunny_talwar]

One way might be this

Sum({< Year = {'$(=Max(Year))'}>}

If(Match(FK_Service, '0', '2208', '2214'), GrossSales_P_RISK_Monthly,

If(Match(FK_Service, '2108'), -GrossSales_P_RISK_Monthly)))