Subtracting in Excel using StudioX

@JohnnyTAK Try the below expression in what to write field within Write Range activity and it did work for me. Please find attached workflow

StudioXExample.zip (72.1 KB)

CurrentRow.ByField("sum(PO Spend)")-CurrentRow.ByField("sum(Amount Invoiced)")

Input

Capture

Output

Capture1

@ushu, i seem to can’t open the file. It’s likely due to restriction of my company computer policy. Please see screenshot of what was applied from your suggestion.

Am i doing this correctly? Thank you,
Johnny

@JohnnyTAK It looks like you are using Write Range Activity. Its should be Write cell since you are using for each row in excel


Thanks for the prompt response. This is now the error received. Sorry for the many iterations.

@JohnnyTAK Can you try this

Cdbl(CurrentRow.ByField("sum(PO Spend)"))-Cdbl(CurrentRow.ByField("sum(Amount Invoiced)"))
1 Like

@ushu, i believe this worked! If i have concerns, I’ll definitely reach back out. Much appreciated!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.