peterhanse Posted October 25, 2016 Report Share Posted October 25, 2016 Good morning , I have a Pivot Table Report . I'm looking for a solution to replace the "13". For the count of all records with kostentest_cat = 1 (that are 13 records). can someone help. CASE WHEN [@field:kostentest_cat] = 1 THEN [@field:kostentest_hoeveelheid]-([@voorraad_ruw]/13) ELSE [@field:kostentest_hoeveelheid] END regards Peter . Quote Link to comment Share on other sites More sharing options...
0 MayMusic Posted January 16, 2018 Report Share Posted January 16, 2018 You can get the COUNT using select statement SELECT COUNT (kostentest_cat) FROM tablename WHERE kostentest_cat= 1 AND ... Quote Link to comment Share on other sites More sharing options...
Question
peterhanse
Good morning ,
I have a Pivot Table Report .
I'm looking for a solution to replace the "13". For the count of all records with kostentest_cat = 1 (that are 13 records).
can someone help.
CASE WHEN [@field:kostentest_cat] = 1 THEN [@field:kostentest_hoeveelheid]-([@voorraad_ruw]/13) ELSE [@field:kostentest_hoeveelheid] END
regards Peter .
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.