Richard Pobi Posted March 26, 2020 Share Posted March 26, 2020 I have a Sales and a Revenue column. When the Sales amount is lower than the Revenue then apply the following logic in a Cross Table. Sales is 5.99 lower(Sum([Revenue]) then 3 End as [status] id,Sales,Revenue,Status 1,100,95,3 2,90,100,1 3,80,100,1 4,105,110,3 5,60,63,3 6,20,30,1 7,30,37,2 8,20,26,2 9,50,52,3 Thanks Link to comment Share on other sites More sharing options...
Shashank Gurnalkar Posted March 27, 2020 Share Posted March 27, 2020 Use the following custom expression: case when Abs(Sum([sales]) - Sum([Revenue]))=6) and (Abs(Sum([sales]) - Sum([Revenue]))=8 then 1 End as [status] Link to comment Share on other sites More sharing options...
Richard Pobi Posted March 27, 2020 Author Share Posted March 27, 2020 It works thanks. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now