About kenzael

Hi everyone,   I have a grid where the user can tick to override an amount. If he ticks override, he can put the new amount below, else it is 0. The problem is that I want the user to be only able to change the amount in the line item "new average salary" if the box is ticked, and not to be able to change the amount if he doesn't tick the box (cell with black font). Is it possible to have a formula that does like : IF Override ? THEN "the user changes manually the amount" ELSE 0 ?   Thank you!   ... View more

Hi,   I have 2 modules : one with the headcount and the other one with average salaries. I want to create a third module with total salaries (which is headcount*average salary).   But, in the headcount module I have the headcount with line items internal vs external, and for salaries I have salary as line item. How can I calculate the total salaries with distinction internal/external if I don't have them as line items in average salaries module? I tried to do a formula like IF is internal? or LOOKUP but I don't manage to make it work.   Thank you for your help! ... View more

Hi,   I created a module with exchange rates data for each month. Then, I put summary as : sum, time: closing balance. But as I only have data until Sep 2020, it puts 0 for FY20 and 21. So, I would like to set up a formula that retrieve the last non-zero value for FY20 and FY21 for instance. Thank you for your help! ... View more