IF ATTR(DATETRUNC('week',[Order Created At]))=ATTR(DATETRUNC('week',DATEADD('week',-1,TODAY())))
THEN [Orders bCancellation]
Change your calculation to above hope this helps.
Plz mark this answer as correct or helpful to close the thread
The calculation was valid but when I tried to put it into the sheet , there were no data appearing in its column.
We need to understand more about the structure of your data in order to get it working. From a logic point of view it's fine, but what does the data look like ? Do you have some sample/dummy data that you can provide ?