calculation only with content

[beck_bakytbek]

Hi Folks,

i got a question (see attached screenshot)

Date,                   Act,                             Budget,                          Delta

27.02.2018             5350130,48                  6492000,00              1414896,52

28.02.2018               -                                   915000                       915000

where: Delta = Budget - Act

on 28.02.2018 i dont have any numbers in Position: Act, but in Position: Budget i have some numbers,

how can exclude the Amount 915000 in Position: Delta, i want to have only 1141896,52

Does anybody have any idea?

Thanks a lot

Beck

[Digvijay_Singh · Accepted solution]

May be -

if(len(Act)>0,Budget-Act,Above(Column(2)))

Or

if(len(Act)>0,Budget-Act,Above(Budget-Act))

[beck_bakytbek]

Hi Singh, Thanks a lot for responce, behind the Act and Budget i stored the variables, can i implement this way on variables?

[Digvijay_Singh]

‌I think first option should work.

[beck_bakytbek]

Hi Singh,

thanks a lot for your help and your valuable time

Have a nice evening