Sum in tables

mitjap — Wed, 10 Nov 2021 16:16:29 GMT

I came to the problem that i hard for me to overcome.

i added screen shot as data files are big

in right table everything is correct as i use to calculate "kos" this expression:

if(Count([Ime delavca])=2,(sum(if(Delavci=2,((kol)/2)))) + (sum(if(Delavci=1,((kol))))), (sum(if(Delavci=2,((kol))))) + (sum(if(Delavci=1,((kol))))))

it uses other fields so i can filter out thing

it works great as i use in table "dat.autocalendar.date" and "kataloška".

the problems is on left table as i dont have "dat.autocalendar.date" and "kataloška" in table. my count and same expresion wont work in left table.

is there possibility that i write expression in left table on the way that is calculate the same as in right table?

topic Sum in tables in App Development