Jump to content
We've recently updated our Privacy Statement, available here. ×

Cross table calculation


Richard Pobi

Recommended Posts

In a cross table I have sum(Actuals), sum(Forecast) and third value column, what I need is whenIf((Sum([Actaul]) + 5)>Sum([Forecast]),1,0) it is working fine, but I want to show it for only EastCoat. The WestCoast should show null or blank.

id, Region,Sum(Actaul),Sum(Forecast), If((Sum([Actaul]) + 5)>Sum([Forecast]),1,0)

1, EastCoast, 10, 7, 1

2, EastCoast, 20, 10, 1

3, EastCoast, 5, 15, 0

4, EastCoast, 10, 10, 1

5, EastCoast, 10, 20, 0

6, EastCoast, 12,8, 1

7, WestCoast, 8, 12,

8, WestCoast, 15, 5,

9, WestCoast, 20, 20,

Attached is the dxp file

Thanks.

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...