Multiple formulas

[vvissamsetty]

I'm trying to create the following filters for a particular output and not sure how to go with this.

1) [Trade Date] = !Null() && [1256 (Y/N)] = 'Y' && [988(a)(1)(B)] = Null() && [988(c)(1)(D)] = Null()   - Standard filter

2a) Filter for 'S' in column AP and filter for all numbers greater than 0 in column 'AI' and then filter for all blanks in column 'AD'. Take subtotal of column 'AI'.

Reset filters back to step 1.

2b) Filter for 'S' in column 'AP' and filter for all numbers greater than zero in column 'AJ'. Take subtotal of of 'AJ'.

Add 2a + 2b for final answer.

Greatly appreciate your help. 

[afv2688 · Accepted solution]

HI @vvissamsetty ,

For your filters:

1) Add a filter tool with the following(!IsNull([Trade Date]) AND [1256 (Y/N)] = "Y" AND IsNull([988(a)(1)(B)]) AND IsNull([988(c)(1)(D)]))     - Standard filter

2a) After 1), add a filter tool with the following ([AP]= "S" AND  [AI] > 0 AND IsEmpty([AD]) and a summarize for AI after it

2b) Add another filter after 1) with the following ([AP]= "S" AND  [AJ] > 0) and a summarize for AJ after it.

Append both fields after it (append tool) and use the formula tool to multiply it ([Summarize1] + [Summarize2])*2

Cheers

[vvissamsetty]

Thanks @afv2688, that worked perfectly . Appreciate your help!