Verify 'text' in Column 'A' then Tabulate Column 'B' where Unique Value is Present - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Verify 'text' in Column 'A' then Tabulate Column 'B' where Unique Value is Present

Last post 02-15-2017 05:47 PM by Curtis. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 02-15-2017 05:47 PM

    Verify 'text' in Column 'A' then Tabulate Column 'B' where Unique Value is Present

    I have a Regional Sales Report, with Column A (Name of Product - text field), and Colum B (Sale Status - text field). I, also, have a Regional Summary Report with Column C (Sale Disposition)

    I am trying to write a formula that determines whether Regional Sales Report Column A is 'ACME"; If yes, then check Regional Sales Report Column B ('ACME lines), for 'Sold'; Count number of 'Sold' lines; Auto-populate sum sold in Regional Summary Report Column C, on the line that represents regiona sales for 'ACME'.

      

    Filed under:
Page 1 of 1 (1 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.