formula won't calculate percentage

[icarecenter]

The conversion doesn't work but my formula calculates only the last entry.  I want to calculate Purchases for each individual date.  It shows 2 for all the dates instead of calculating just the purchase for that particular date.

[Suvrutt_Gurjar · Accepted solution]

You seem to be using a real column to add purchases by date. Note that a real column for a row will update only when the corresponding row is edited.

So to compute purchases by date in real column of a row , you may want to use actions or you may want to aggregate purchases by date in a VC. However VC expressions are typically sync time expensive.

Also your expression SUM(SELECT(..) could be syntactically correct as follows

SUM(SELECT(Date[Purchase], [App date]=[_THISROW].[App Date]))

This expression could be in a VC.

edit: made minor change in the description of the second sentence. Replaced the verb updated with edited.