topic Re: query in App Development

query

Nitesh_Jaiswal — Tue, 06 Dec 2022 08:48:52 GMT

i want Total while Having value 0 to Th sale

SO As In 3rd Line IT is showing the value 0 But But I want Total Value As 1250

Re: query

kfoudhaily — Tue, 06 Dec 2022 13:56:22 GMT

if I understand well your question, here is the expression to use:

if(Dimensionality()=0,sum(sale),if(sale>0,0,'N'))

please don't forget to accept response if it's ok for you.

regards,

Re: query

Nitesh_Jaiswal — Wed, 07 Dec 2022 06:27:33 GMT

thanks for the solution this is what we needed. but i have one q as can we use only those two table one is dimension which is zone and and another that expression table only , i dont want to show that sum(sale) row.

Re: query

Nitesh_Jaiswal — Wed, 07 Dec 2022 06:28:01 GMT

Re: query

kfoudhaily — Wed, 07 Dec 2022 08:46:09 GMT

i'm not sure I understand, can you develop a bit more?

regards,

Re: query

Nitesh_Jaiswal — Wed, 07 Dec 2022 09:14:35 GMT

i want like this but whenever i remove that sum (sale)i get this

Re: query

Nitesh_Jaiswal — Wed, 07 Dec 2022 09:15:58 GMT

i want thisbut i get this