Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
try below
Sum({< Year = {'$(=Max(Year))'}, FK_Service = {'0', '2208', '2214'} >- <Year = {'$(=Max(Year))'}, FK_Service = { '2108'}>} GrossSales_P_RISK_Monthly)
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)))