Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi guys
I have a data tables as per example below (0 means that there was no submission)
Partner | month | Number of Working Days |
P1 | Jul | 5 |
P1 | Aug | 8 |
P1 | Sep | 12 |
P2 | Jul | 0 |
P2 | Aug | 0 |
P2 | Sep | 0 |
P3 | Jul | 5 |
P3 | Aug | 12 |
P3 | Sep | 0 |
P4 | Jul | 0 |
P4 | Aug | 0 |
P4 | Sep | 6 |
P4 | Jul | 6 |
P4 | Aug | 8 |
P4 | Sep | 18 |
then I have Chart table with calculated field
Partner | Months not received |
P1 | 0 |
P2 | 3 |
P3 | 1 |
P4 | 2 |
P5 | 0 |
So basically I am checking how many months partner does not sent data to us.
I created 2 buttons 1 is to show all partners who does not sent us data at least once.
To do so I simply using action select in filed if value is 0.
Now I need to select all partners who always (in selected pried of time) submitted data.
If I will use same logic as for not submission it will select any partner who submit data at least once (which is incorrect)
Unfortunately I cannot use field "Months not received" as it is caluclated field.
I was trying to make it with set analyses, but without success.
is there a way to do this in VBA? or at least is there is some proper manual for VBA so I can do that by myself?
I thought about something like:
Loop "partner"
if min("number of working days" - "for selected period of time")<>0 then
ActiveDocument.Fields("partner") .select
end if
next
yes, yes, I know, this is incorrect code, but it shows the logic that I think can be used there
Or maybe there is a way to use "Months not received" and just filter 0?