I want to do something like in the example, h...

(Test Birimi) #1

I want to do something like in the example, how can I get the previous value for comparison.

what should be the formula for the previous value?

Thanks

(Test Birimi) #2

Can you help me?

(Aleksi Alkio) #3

You can write the previos value with the app formula like LOOKUP([_THISROW].[DATE],TableName,“Date”,New Value). Please remember that the value will change every time when you open & save the record even if you didn’t change the “New value”.

(Test Birimi) #4

@Aleksi_Alkio @Lynn

Any other suggestions? Please help, I want to write the previous date and value on each line.

(Test Birimi) #5

and these values will not change

(Yılmaz Kandiş) #6

@Test_Birimi You can also try to get previous row value in Google Sheets by using OFFSET function

(Aleksi Alkio) #7

The LOOKUP expression will do the job if you use the key column for it. In this sample I assumed that it would be the Date but it’s probably the ID when I checked your table structure again.

(Test Birimi) #8

@Aleksi_Alkio I submitted a table structure.

#9

Hi @Test_Birimi I may have misunderstood your question but If Aleski solution is not doing the job, maybe try adding a VC to get the previous date and then use that to select new value for previous value.

MAX(SELECT(tblName[Date],[Date]=<[_THISROW].[Date]

then for previous Value select(tblName[New Value],[Date]=[VC].[DATE]

(Test Birimi) #10

@Lynn

thanks i try now

(Test Birimi) #11

@Lynn

select(tblName[New Value],[Date]=[VC].[DATE]

[VC].[DATE]

Error in expression [VC].[DATE]

(Test Birimi) #12

I can not do this part, it gives an error

(Test Birimi) #13

what is the problem?

#14

Hi try ANY(SELECT… and put in your column and table names etc.

(Test Birimi) #15

ANY(Select(Table[new value],[Date]=[VC Date].[Date]))

(Test Birimi) #16

I understood in this way, but unfortunately did not happen