Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm having trouble creating the following situation:
In the attached file, if you have a table watching a table A1 and A2, must take the field values "META" for table A2 considering the value of last "MES" ie when I select "AGO" (August), the table A1 should I bring values AGO (August) and the field META (Goal) bring me the value of JUL (July) in order to know if the value I am quoting the current month is less than or greater than the value quoted in the previous month.
See attached qwv
Thank G Wassenaar!
G Wassenaar, is possible in the same situation when the value of the previous month is 0 it will bring the lowest value of the first record to find?
Example: August target value is July, but July is equal to 0, then it bring me the value of June.