Dashboards & Analytics Discussions
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Result sets

I have an insight created using result set. I have another main insight. Is it posssible to join/ combine my main insight with the insight I have created using result set?

Resolved! lookup formula/grouping

 I have three columns column 1 column 2 and column3. column1 is coming from a mv, column 2 is coming from a business schema and column3 is a look up formula. I have filtered on column1 and column2 as you can see the values are same for 2 rows for the...

Tarashah76_1-1715841648322.png

Resolved! Distinct count

can someone advise me a formulae for below case, i want to count the  no.of invoices with invoice amount <>0case(    Invoice Amount > 0,     distinct(        Invoice Number),         '0'    ))

MT10 by Ranger
  • 283 Views
  • 1 replies
  • 0 kudos