topic Re: Calculation not working as expected in App Development

Calculation not working as expected

egoss_cynosure_ — Sat, 16 Nov 2024 04:45:37 GMT

Can some help me figure out why the following calculation would return a zero if I don't have the [Date - Invoiced] field in the table? I've created measures like this in the past without the field being used in the condition and they've worked.

I've tried the AGGR (with Rep Name and/or date) function in the sum and that's not working either.

if([Date - Invoiced] >= [Territory - Level 1 Rep Start Date], sum([Amount - Shipped/Fulfilled USD]), 0)

Rep Name	Sales
SMITH, JOHN	$0

Re: Calculation not working as expected

sunny_talwar — Fri, 06 Sep 2019 00:20:29 GMT

Try this may be

Sum(If([Date - Invoiced] >= [Territory - Level 1 Rep Start Date], [Amount - Shipped/Fulfilled USD]))

Re: Calculation not working as expected

sugathirajkumar — Fri, 06 Sep 2019 07:06:53 GMT

can you share your file pls

Re: Calculation not working as expected

egoss_cynosure_ — Fri, 06 Sep 2019 10:29:51 GMT

Thank you!

Re: Calculation not working as expected

egoss_cynosure_ — Fri, 06 Sep 2019 13:08:28 GMT

I thought this worked, but unfortunately it's not. I'm seeing very results that are much higher than expected.

Re: Calculation not working as expected

egoss_cynosure_ — Fri, 06 Sep 2019 13:09:41 GMT

I can't - this is sales data.