Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a method to sum a number value with a caculated expression? e.g.
(Sum({<[Month Year]={'$(=Max(Date([Month Year], 'MMM-YYYY')))'},
[Customer_Code]=-{'A','B','C','D'}>} USD_Revenue)) and Sum(5000)
where the value returned would be 5000+ the calculated value from the data loaded?
(Sum({<[Month Year]={'$(=Max(Date([Month Year], 'MMM-YYYY')))'},
[Customer_Code]=-{'A','B','C','D'}>} USD_Revenue)) + 5000
THANKS! It worked
can I expand this with a if condition e.g.
(Sum({<[Month Year]={'$(=Max(Date([Month Year], 'MMM-YYYY')))'},
[Customer_Code]=-{'A','B','C','D'}>} USD_Revenue)) + (if([Month Year]={'Dec-2022'}, 5000, 3000))