Can I subtract 2 rows directly in data manager with add field

[jmarchand]

Can I subtract 2 rows directly in data manager with add field?

Like the following example.

Thanks

[trdandamudi]

Give a try on the below code:

I Option:

Data:
Load *,
Value-Peek(Value) as Result;

Load * Inline [
FiscalMonth,Value
Apr,100
May,300
Jun,250
Jul,400
Aug,350
Sep,550
];

II Option:

Data:
Load *,
if(rowno()>1,Value-Peek(Value),Value) as Result;

Load * Inline [
FiscalMonth,Value
Apr,100
May,300
Jun,250
Jul,400
Aug,350
Sep,550
];

[sunny_talwar]

When you say data manager, do you mean script?

[jmarchand]

[jmarchand]

Do you undestand why I mean with this screeshot?

Thank you.