Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Stuck into develop below logic please help.
Column D is a formula for reference to calculate column C Please help
MONTHS | Amount | Reduction | Formula |
OPENING | 542.8 | 0.0 | B2-C2 |
3 | 541.2 | -2.6 | B2-C3 |
4 | 538.6 | 0.0 | B2-C4 |
5 | 537.2 | 1.4 | B2-C5 |
6 | 533.1 | 5.5 | B2-C6 |
7 | 528.0 | 10.6 | B2-C7 |
8 | 528.0 | 10.6 | B2-C8 |
9 | 528.0 | 10.6 | B2-C9 |
Do you mean to say for example C2=B2-C2? I can't understand.
see below condition
if( month='opening',GNPA,0) - GNPA
I want to substract all GNPA Amount from 542.8
Do you get opening as it is in Month Data or it is calculated?
'Opening' is hard coded value in script for month column.
and other number are DAY(TODAY())
Just adding a new comment to kick this one back out to see if someone else may be able to offer up anything, I am not sure I am the right resource to try to help on this one, sorry.
Regards,
Brett
@Harsh9971 your column D formula completely differs from formula in C. It's confusing. Can you please update?