Multi Column formulae

Question

Hi I am looking a short way to write the formulae to calculate the difference of below

Like Redemption_A_Sum_Cost - Redemptions_A

Redemption_B_Sum_Cost - Redemption_B and so on for 1000 of similar columns

Instead of writing manually - I am sure there is a shortcut to calculate

like in excel if you write B4-C4 and simply drag that formulae to other cells give you the results

Attaching the file

Multi formulae.xlsx

afv2688 · Answer

Hello @ammar90 ,

let me know if this works for you 🙂

Regards

diff_calculation.yxmd

pedrodrfaria · Answer

Hi @ammar90

You can try to create a different logic instead of using the formula tool to just manually do the calculations. Event though, at least looking at this example, if you be MUCH quicker to just write the functions using the formula.

The other logic would be to do a transpose and then a crosstab to align the respective columns for the correct calculation to then do the calculations, but this isn't the best logic to use in this case imo.

Pedro.

AngelosPachis · Answer

Hi @ammar90 ,

Here is one way to do it. It needs a bit more effort than dragging/dropping in Excel, but it still works I think

example.yxmd