Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to apply excel style formula in my App. Below is sample of what I want to implement
A | B | C | D | E | F | G | H | I |
---|---|---|---|---|---|---|---|---|
Jan | Feb | Mar | Apr | Mar | Apr | |||
Measure 1 | 10 | 20 | 30 | 30 | Measure4 | -10 (=D3-C4+B5) | 0(=E3-D4+C5) | |
Measure 2 | 40 | 50 | 50 | 50 | ||||
Measure 3 | 10 | 20 | 40 | 40 | ||||
Measure1 to 3 are defined in the data model. I want to display Measure4 in a table with Month Dimension and calculated as per the formula.
Hi,
Try with Column(...) and also with Above(...) and Below(...)
If possible upload a sample app with sample data and the expected outcome. It's not clear is you'd like to show two numbers for every month. What's F and what's G
I hope this helps,
Cheers,
Luis
Thanks Luis!!
These are 2 separate tables to be replicated on a sheet. Column A to E is one table and Column G to I is a separate table. Column H is just a blank space and of no significance. I can't use Column() or Above() or Below as these apply in the same table. Moreover my first 2 columns would be blank as these are based on measures in previous 2 columns.